Help with Combination Charts

[Dawny]

Hi,

I hope someone can help me.

I am wanting to create a combination chart which has a bar chart and a line chart on the same graph. However my problem is that the two data sets I am plotting are for differnt times eg one is on an annual basis and the other is on a quarterly basis. All I want on the x axis is the year (not quarters) and ideally I want the annual data plotted in a bar and the quarterly in a line.

Can anyone help me with this as I am really struggling?

Thanks in advance

Dawny

 

[tusharm]

If you have only years on the x-axis how do you envison the quarterly data appearing on the chart?