Problems with overlapping certain data in a series

[elizabeththompson]

Hi,

I am trying to represent 3 years of financial data and want to break down the data into 2 subsets giving me 6 series in total. I want the first 4 series (the first 2 financial years data) to be in a column graph and the third financial year's data (2 series) to be presented as a line graph which I have managed to do.

My problem is that I want my data for the individual series in the financial years to overlap so that instead of having 4 columns showing data for the two financial years, I want 2 columns, with each column showing the data for the financial year. I have tried to do this but when I overlap, all the column data overlap so that I go from having 4 columns to 1 column not the 2 columns that I want.

If anyone can provide any advice it would be greatly appreciated.

Thanks.

 

[Andrew Poulsom]

Welcome to the Board.

Is it something like this that you want?

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

 

[elizabeththompson]

That's brilliant, thanks!!