How do i change the stack of colours chart to values not percent?

  • Thread starter Thread starter Nikky Noo
  • Start date Start date
N

Nikky Noo

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
 
Back
Top