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 / November 2006

Tip: Looking for answers? Try searching our database.

Replace Chart Values with Second Set of Values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brian Erhard - 29 Nov 2006 17:45 GMT
Hello,

I would like to create a "100% Stacked Column" Chart using the over
simplified example below:

      % in 2002       $ in 2002       % in 2003       $ in 2004
x       10%     $200    12%     $210
y       20%     $400    24%     $450
z       70%     $600    64%     $1,000

I would like the bars of the chart to be divided based on the
percentages (% in 2002 and % in 2003), but I instead of the values of
the percentages appearing I would like the dollar amounts to appear.

Any suggestions?

Thanks.
Jon Peltier - 29 Nov 2006 20:47 GMT
I saw this question a couple days ago on another forum.

Use one of these free and well-made Excel add-ins to apply labels from the
dollar ranges to the series made with the percentage ranges:

   Rob Bovey's Chart Labeler, http://appspro.com
   John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Hello,
>
[quoted text clipped - 13 lines]
>
> Thanks.
 
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



©2008 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.