Showing unrelated values according to the X axis
 

hello - I want to show the % of holding types in a number of accounts for each month. Say I have 1500 accounts that hold together 2500 holdings, split 60/40 betw type A and type B. I can do 100% stacked bars for the 60/40 split by month, but how can i show next to/on each column an UNRELATED number (in charting terms) which is the number of accounts for each month (that hold the holdings that I am showing the split of). Is there a slick way I can associate to each month the unrelated value, without effect on the chart other than showing the value for each month referring to the stacked column ? thank you

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

one possible response to my own Q
 

Well poking around in peltier land, I found the AppsPro labeller, and this seems to work - is there another XL way ?thank you

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

my own rsponse
 

Ok, have been using the Peltier miracle tool, thank you

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

my own rsponse
 

It's not my tool, it's Rob Bovey's. But I agree that it's a powerful
addition to Excel.

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



<me wrote in message ...
Ok, have been using the Peltier miracle tool, thank you

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

one possible response to my own Q
 

On Fri, 9 Mar 2007, in microsoft.public.excel.charting,
lid said:

Well poking around in peltier land, I found the AppsPro labeller, and
this seems to work - is there another XL way ?thank you

It (Rob Bovey's AppsPro labeller) is the one I prefer, but John
Walkenbach's J-Walk Chart Tools also contains one that you may like
better.

http://j-walk.com/ss/excel/files/charttools.htm

This also contains other utilities, such as a way to access Excel's
built-in facility for exporting charts to GIF and other picture formats,
that is not available from the menu in regular Excel (why??)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.