Plotting monthly and quarterly data on one line chart

[waptrick]

Hello everyone,

I am trying to plot a monthly series on the same chart as a quarterly series. The problem I am having is that the quarterly data does not extend across the entire chart despite having the same start and end dates as the monthly series. Is there a way to format so I have two y-axis but one x-axis with both series spanning the entire chart?

Thanks

 

[NdNoviceHlp]

Hi waptrick. It can be done. Here's some VBA...

Change Chart to 2-Y Axis in VBA

The code is selecting a range of cells Range(ActiveCell, ActiveCell.Offset(daysinmonth - 1, 1)).Select right before it creates the chart tab. When the chart is created it plots only the second column of data(first column is correctly identified as X-axis). I'm trying to figure out how to...

www.mrexcel.com

See Jon Peltier's site here... Align X Axis to Y=0 on Two Y Axes
HTH. Dave