This chart reflects actuals so much in a solid line with forecast numbers in a dashed line. The chart form is set to line chart, and also actual and also forecast values are plotted as 2 data series. The data provided for the graph is collection up as displayed below:

*

How to make this chart

Select the data and also insert a line chart:
*
Choose the very first option, a basic line chart:
*
Chart together inserted:
*
Select estimate data collection and use dashed line:
*
After setup dashed line on projection data series:
*

From this point, you can set the chart location and move the legend.

 




You are watching: The plotted graph for actual demand shows:

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts because that Windows and Mac in one comfortable PDF.

email

*
Hi - I"m Dave Bruns, and I run surfacetoairnewyork.com through my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and also clear examples of formulas, functions, pivot tables, conditional formatting, and also charts. Read more.

*




See more: Call Of Duty Black Ops 3 Hardened Edition Ps4, 15 Results For Black Ops 3 Hardened Edition Ps4

I have been taken into consideration a spreadsheet expert for numerous years, but I believe my complete Excel expertise is likely less than 30% the what I've seen in her weekly e-mails and also website...In today's fast-paced office, once I need to understand "how", surfacetoairnewyork.com is absolutely the best resource I've found for keeping my skills up-to-date there is no spending much time trying to find answers. Thank you!!! -Suzanne