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)? |
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)? |
All times are GMT +1. The time now is 05:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com