Complex Charting in MS Excel

gkhurram

New Member
Joined
Nov 22, 2011
Messages
1
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
:mad:Khurram:mad:
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,102,288
Messages
5,485,912
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top