Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #07: X-Y Scatter Chart: Fixed Cost Variable Cost Model

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn how to create a Fixed Cost Variable Cost Model X-Y Scatter Chart that has a plotted Break Even Point and a Legend Entry that shows the actual Break Even Units Point when the formula Inputs are changed: 1) (00:14) Introduction to our Goal of creating an X Y Chart for Break Even Analysis 2) (01:36) Problems with Chart an X Y Scatter Chart Break Even Analysis by using the Data Table feature. 3) (03:34) Highlight Values and Plot on X Y Scatter 4) (05:16) Remove and Edit Series values using the Select Data dialog box 5) (07:31) Move Legend 6) (07:54) Add Axes Labels 7) (08:51) Plot Break Even Units Point on Chart 8) (10:27) Create Label for Legend that shows Break Even Point using a Text Formula 9) (11:14) Add a New Single X-Y Marker Series to the Chart using the Select data dialog box 10) (11:48) Find a Chart Element when it appears to be hidden 11) (13:25) Change Formula Inputs and see that the entire model updates, including the Chart and the label that lists the Break Even Point that sits in the Chart Legend Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.