secondary axis in combination charts

Good morning. =)

I am trying to create a combination chart in Excel for copying into PowerPoint for a presentation.

There are three data series: projected quarterly sales, actual quarterly sales, and monthly sales. The first two are depicted as bar chart; the monthly sales are a line graph. I was able to edit the data source by to get a multi-level category axis.

I would like for the bars to correspond only to the appropriate quarterly mark on the horizontal axis, but they appear above a particular month in that quarter due to their positioning on the spreadsheet. How do I tweak this chart so the bars correspond only to quarterly labels on the multi-level category axis and the line corresponds only to the monthly labels?

My file is attached. Thanks! =)

Originally Posted by Chafe

Good morning. =)

I am trying to create a combination chart in Excel for copying into PowerPoint for a presentation.

There are three data series: projected quarterly sales, actual quarterly sales, and monthly sales. The first two are depicted as bar chart; the monthly sales are a line graph. I was able to edit the data source by to get a multi-level category axis.

I would like for the bars to correspond only to the appropriate quarterly mark on the horizontal axis, but they appear above a particular month in that quarter due to their positioning on the spreadsheet. How do I tweak this chart so the bars correspond only to quarterly labels on the multi-level category axis and the line corresponds only to the monthly labels?

My file is attached. Thanks! =)

Attached is a file that may help