Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide one month in a chart | Charts and Charting in Excel | |||
Excel Chart which updates every month - how? | Excel Discussion (Misc queries) | |||
Loosing 1 month on my chart | Charts and Charting in Excel | |||
3 month rolling chart | Charts and Charting in Excel | |||
adding new month to chart | Charts and Charting in Excel |