elizabeththompson
New Member
- Joined
- Nov 21, 2005
- Messages
- 2
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.
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.