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

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display the merge function "url" of a picture? 0
How do I lock the colours in a chart (red, amber, green) 2
sideways stacked bar charts with line series on the same axis 0
How do I create a Line Chart (Special) 1
How do i change the default colours for charts in Excel? 1
Autoscale a Line Chart to stack the curves 5
How can I change the theme colours to original standard 40 colours 0
how to switch the primary and secondary Y axis to opposite chart s 2

Top