I have a bar chart that lists months and shows the percentage. I would like to compare the 1st quarter average from this year to last year. I do not want to compare the months individually, just the 1st quarter. Does that make sense? I have attached a picture where I have what I want to do separated into 2 charts. I want to take the bars from the 2nd chart and add it to the first without comparing anything to Jan, Feb, or March. Any help?
excel chart.png
Bookmarks