Showing unrelated values according to the X axis

[Pierre]

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

 

[me]

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

 

[me]

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

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

 

[Jon Peltier]

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

- Jon

 

[Del Cotter]

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??)