Comparison bar graphs

  • Thread starter Thread starter Elise
  • Start date Start date
E

Elise

I would like to have a bar graph showing a comparison between numbers
from three years. This is my data:

Jun-06 1164
Jun-07 1284
Jun-08 2128

Jul-06 1375
Jul-07 1649
Jul-08 2316


Aug-06 1585
Aug-07 1694
Aug-08 2374

I can get this information to show up as a bar graph, but it is in
chronological order (June 2006, then July 2006, etc.). I would rather
have all of the June numbers side-by-side, then all of the July, etc.
so I can show a month-by-month comparison. I also do not want all of
the other months of the year shown along the x-axis, just June/July/
August.

Is this possible to do easily in one graph in Excel or would I have to
create three graphs, one for each month?

Thanks in advance for any help you can give.
--Elise
 
Just change the first date into text : Key "'Jun-06" (without the double
quotes, with the single quote). Then select the whole data and make your
graph.
 
Back
Top