| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with Quarterly and Monthly Results
I was given 75 charts that were pre-built in specified format. The chart
uses a line chart for actual sales results and a bar chart for sale targets. The data is quarterly. I have been asked to keep the chart in the same format, but update our progress towards the quarterly target each month. So the x-axis would be Q1 Jan Feb Mar Q2 Apr May June Q3 etc. The data in the pre-built chart is formated: Q1 Q2 Q3 Q4 Act Sales Sale Target Any Sugggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Monthly Data, need quarterly Stdev | Excel Discussion (Misc queries) | |||
| How to merge monthly workbooks into a quarterly workbook?? | Excel Worksheet Functions | |||
| monthly quarterly splitting | Excel Discussion (Misc queries) | |||
| From Monthly to Quarterly Numbers | Excel Discussion (Misc queries) | |||
| Excel - sum a column of sales monthly and quarterly? | Excel Worksheet Functions | |||
Linear Mode
