View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
DCHenry DCHenry is offline
external usenet poster
 
Posts: 1
Default Bar chart by month

I have a spreadsheet that has month & year in column A and values (KWH) in
column B like:

Jun-00 1185
Jul-00 2636
Aug-00 3009
etc.

I would like to create a chart (and/or spreadsheet) that is grouped on the
months and shows the average value for that month and where each year is in
relation to that average. I envision a chart/speadsheet something like:

3000

2000

1000

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
Dec

with bars on each month for that months data and a line/curve showing the
average for each month.

Thanks.
DCH