View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Disruption of order of data series in 100% stacked charts

Could you also post some typical data?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sylvain" wrote in message
...
I have built a 100% stacked chart based on 4 yearly series.
My problem is the series are not displayed in the same order in every
stack.
In one of the stacks, one data point jumps up from the bottom to the
center,
like so:
a a a
b d b
c b c
d c d
2001 2002 2003
(d jumps up in year 2002)

I would like the series to be aligned and so to appear in the same order
in
every stack.
Tweaking the series order setting only serves to displace the problem.
Thanks for any suggestion.