| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a chart that compares monthly data with an average
Excel 2003:
Jan Feb Mar Moe 20 24 16 Joe 15 28 24 Flo 25 22 12 Ok lets say the average sales per month for last year was 22. I want to make a plain clustered column chart that shows what Moe Joe and Flo each sold for Jan Feb and Mar and want the Average Sale from last year to be beside each group of columns so each persons sales are compared to the average from last year. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for annual average from monthly data | Excel Discussion (Misc queries) | |||
| create a macro that compares two workbooks | Excel Discussion (Misc queries) | |||
| Create Monthly Spend Chart | Excel Discussion (Misc queries) | |||
| How do I create a YTD table which compares production for 4 facil. | Excel Discussion (Misc queries) | |||
| How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
Threaded Mode
