Stacked Bar Chart Over 100%

B

Brian

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)?
 
E

Earl Kiosterud

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