Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / July 2006

Tip: Looking for answers? Try searching our database.

stacked bar chart with percentages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
name - 20 Jul 2006 15:58 GMT
I have a time series stacked bar chart that consists of three products.
I would like the labels for each product to show that product'
percentage of the total of the three products.  How can I go abou
accomplishing this?  I've seen previous repsonses to similar posts tha
recommend plotting the percentages, but I don't think that alone woul
solve my problem.  I would still like to show the trend of the thre
products total, which wouldn't be available if I plot the percentage
only, as all bars would equal 100%.  Thanks for any help provided
Gklass - 20 Jul 2006 18:30 GMT
Interesting problem.  The Y-axis scale and the data series you want to
plot should be the raw number data.

I think the best way to do it would be to plot the raw data and then use
the J-Walk chart labeller to label the percentages on each bar segment.

> I have a time series stacked bar chart that consists of three products.
> I would like the labels for each product to show that product's
[quoted text clipped - 4 lines]
> products total, which wouldn't be available if I plot the percentages
> only, as all bars would equal 100%.  Thanks for any help provided.
name - 21 Jul 2006 14:28 GMT
Thanks for the tip.  Had never heard of j-walk before.  Great site.

Signature

name

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.