I'm using Excel 2003 and need to display a chart showing how a stack of
colours chnages over time for 3 different products. The closest chart is
either the stack of colours - but this is done in percent, or the 'Tubes' -
which is done with the axes reversed/wrong way round .

Can anyone help with how to swap the axes for the tube chart type OR show
the stack of colours chart type using values not percentages?

Thanks

When you select the column chart type, the top row of subtypes are clustered
column, stacked column, and stacked to 100% column. Right click on the chart
area or plot area of the chart, select Chart Type, and choose the stacked,
not stacked to 100%, column chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Nikky Noo" <Nikky wrote in message
...
I'm using Excel 2003 and need to display a chart showing how a stack of
colours chnages over time for 3 different products. The closest chart is
either the stack of colours - but this is done in percent, or the
'Tubes' -
which is done with the axes reversed/wrong way round .

Can anyone help with how to swap the axes for the tube chart type OR show
the stack of colours chart type using values not percentages?

Thanks