Can Bar Chart/Column Chart show 2 lots of info per column

[Vaun]

Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I need to compile a bar chart that shows a gross figure for every week (so I will have 52 'bars' of varying heights). I also need to show what proportion of each bar is made up of a certain item (i.e. if week 1 revenue = 12, and best selling item = 8, the first bar will be 12 units high, but two thirds of it (8 units) will be a different colour).

I'm sure there's a clearer way to explain this - apologies if this is confusing.
Any help gratefully appreciated. Excel novice.

Using Excel 2004 for Mac. Version 11.5.4 on OS X 10.4.11

 

[Vaun]

I worked this one out myself. a little embarrassed I didn't think of it sooner. Created a new column that had the values of weekly gross revenue minus the best seller each week. Then created a regular bar chart with the data from the best sellers column and the 'difference' column.

There's probably a more elegant solution, but it worked for my purposes.