100% Stacked Area How can be seperate?

[desertpunk5339]

Hi again..

Anybody who have knowledge how to seperate datas in 100% stacked area chart?
the task is to use 25% gridline interval between each series

Kindly checked my attachment..
The image beside the chart must be the outcome..


i have been research about it but no luck..


Thanks

[Steve N.]

Haven't seen that done in a pivot chart...

Does the attached, grouped charts scenario work for your situation?

[Andy Pope]

You can do it in a single standard chart by calculating the padding areas.

Not sure you can calculate those values in a Pivot table.

[desertpunk5339]

Thanks for the help experts

This 2 works!

It's the first time i saw grouped charts :D so ill try the second one
I'll try to study the grouped chart when i finished studying the second one.. it' a new knowledge

BIG thanks again Sirs