Chart with Quarterly and Monthly Results

G

Greg A

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Combination chart: Stacked Column + Stacked Column 4
Help with 2007 Chart Layout 1
Stacked Column Chart with 2 different axis values 0
Combination Column and Stacked Column Chart in XL 2007 1
Column chart - data labels problem 4
can't center a category label on a line chart 1
Quarterly date format issues 5
SUMIF with VLOOKUP nested 4

Top