Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
100% stacked column chart with negative numbers
How do you create a 100% stacked column chart with negative numbers? After I
create the chart it only goes up to 80% |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
100% stacked column chart with negative numbers
How do you want it to show? The total length (including negative amount) of
the column should equal 100%. (make sure you haven't limited the scale of your y-axis) What the graph is showing you is that the positive numbers do not account for 100% of your data. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Stuck" wrote: How do you create a 100% stacked column chart with negative numbers? After I create the chart it only goes up to 80% |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
100% stacked column chart with negative numbers
By definition you cannot (or at least should not) have negative numbers in
this type of chart. It's like trying to show negative numbers in a pie chart. You could expand the Y axis of your chart so it shows negative numbers, and the chart will show X% negative and (100-X)% positive. In your case, 100% doesn't go from 0% to 100%, it goes from -20% to 80%. Without knowing more about your data, it's anyone's guess how better to show the data. Perhaps a clustered chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Stuck" wrote in message ... How do you create a 100% stacked column chart with negative numbers? After I create the chart it only goes up to 80% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Editing a column chart for Variance Walk negative numbers | Charts and Charting in Excel | |||
stacked column chart with negative values | Charts and Charting in Excel | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |