Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brian
 
Posts: n/a
Default 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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Create stacked columns chart but with 2 columns for each x axis? PSM Charts and Charting in Excel 2 May 7th 05 03:56 PM
Create a custom chart, two stacked bars/month w/ two axes? Oscar Charts and Charting in Excel 1 March 21st 05 11:07 PM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM
How to make a stacked bar chart using time? Jon Peltier Charts and Charting in Excel 0 February 3rd 05 05:56 AM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"