Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stacked Bar Chart Over 100%
Currently have a stacked bar chart showing to 100% (the plan) by 8 clients,
how can I show that 3 of the 8 will be over 100% (greater than plan)? |
#2
|
|||
|
|||
Brian,
If this is a normalized chart (the one on the right in the chart types), it will always be 100%. You'll have to use the middle one. Are these percentages (as they appear in the worksheet)? If so, use the regular stacked chart (the middle one), and the axis should adjust to accomodate whatever your greatest percentage is. -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "Brian" wrote in message ... Currently have a stacked bar chart showing to 100% (the plan) by 8 clients, how can I show that 3 of the 8 will be over 100% (greater than plan)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
How to make a stacked bar chart using time? | Charts and Charting in Excel |