How to show Monthly vs YTD Comparison Chart?

user06240

Hi all,

 

I am looking to create a chart showing  a comparison between Monthly and Year To Date numbers for Actuals and Forecast

 

Thanks in advance

BlueRooster

Some of this will depend on how you have your data setup (mainly whether you have already have a YTD column totaling your actuals and forecast through each month) If you don't have that, you'll need to add those two columns ahead of time. 

So your data may look like this:

 

Once you have that, youll put your Month column as your X axis, your two YTD columns next in your Y axis and then your two Monthly columns. It might look something like this:

 

Finally, with the Line + Grouped Bar chart type selected, go to the General tab and set Series on Left Scale to 2. 

 

That should give you the chart you're looking for.

 

Sincerely,

Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.