Complex Charting in MS Excel

[gkhurram]

Hi,

This is first time that I am posting to any blog/forum ever, I just wanna discuss if it is possible to make a chart in excel in such a way that every category has 3 comparative series (a simple column chart) but the third series should be as stack series for example. I made a chart compare annual sales with annual targets and Last year's sales. I update this chart on monthly fortnightly basis. want to see the current annual sales as stacks, i.e. how much in each fortnight or month while last year's sales and annual target's are simple columns.


categories | Last Year | Target | Current
A | 10 | 15 | 9
B | 212 | 275 | 213
C | 4351 | 5132 | 2512
.
.
.
.
and so on

figures in each category, (a,b,c) are total values for the year have been updated in about 9 months, breakup of these 9 months must be stacked.

Any help will be appreciated.

Thanks
Khurram

 

[Robert Mika]

Hi Khurram and welcome to the forum
Look here:
http://www.mrexcel.com/forum/showthread.php?t=592174

This is very close to waht you need.
You just need to add another series.