ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I graph this? (https://www.excelbanter.com/charts-charting-excel/26833-how-do-i-graph.html)

Lisa

How do I graph this?
 
I have 5 measures I want to depict in a graph showing each month's goal
versus actual, for each month of the year. Each measure has a different
start and end date throughout the year. For example, measure 1 may not have
a goal until june so I don't want the measure to appear to be reporting as if
it's not being done on time, when it's not due until June. It was suggested
I use a stacked bar graph but I"m struggling in understanding how to have the
bar graph have a goal for each measure if it's reported in a stacked bar.
Any suggestions? If not a stacked bar graph what would be a better solution?


Thanks for any help!


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com