If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do i change the stack of colours chart to values not percent?
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 |
#2
|
|||
|
|||
How do i change the stack of colours chart to values not percent?
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 |
Thread Tools | |
Display Modes | |
|
|