| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
my own rsponse
Ok, have been using the Peltier miracle tool, thank you
EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing a break in the Y axis | Charts and Charting in Excel | |||
| showing all values on the Y axis | Charts and Charting in Excel | |||
| x axis not showing correct values | Charts and Charting in Excel | |||
| Axis values showing incomplete | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
![Pierre[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
