Hi
I have some data I need to try and put into a column chart. I need to combine several colums of data (but not all columns)into one overall column but have each data series that make up the total coloured differently.
e.g. I have income from 3 different sources (say Curly, Larry, & Mo), but one expenditure source. I want to produce a stacked column chart for the income (with the 3 sources in different colours), and then have the expenditure along side the income column.
Income is say Curly £40, Larry £30, Mo £30. Expenditure is £80. I want the income in 1 column to total £100 (split between the 3 sources each a different colour) and the expenditure of £80 along side the income column.
I have attached a simple example which might explain things better.
Thanks
James
Bookmarks