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?