Previous Thread

8/17/2006 1:03:01 PM    Create and customize axis on all sides of charts
It would be very helpful, especially for large charts, to be able to 
 
define/create an axis for all sides of the chart.  Currently you can only 
 
have a secondary axis if you have multiple data sets in the chart, but it 
 
would be great if you were able to have the chart print the secondary axis 
 
even with a single data set.  If this was possible, it would make sense to 
 
have each axis be independent of the others, allowing for custom scale, 
 
units, formatting, etc. 
 
We have several professors asking for this feature, and currently they have 
 
to kludge the chart to get it.  For the sake of my own sanity, *please* 
 
implement this in Excel 2007 :) 
 
---------------- 
 
This post is a suggestion for Microsoft, and Microsoft responds to the 
 
suggestions with the most votes. To vote for this suggestion, click the "I 
 
Agree" button in the message pane. If you do not see the button, follow this 
 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
 
click "I Agree" in the message pane. 
 
http://www.microsoft.com/office/community/en-us/default.mspx?mid=b1d203a6-40d2-4281-beb0-1c8e723ce712&dg=microsoft.public.excel.charting



8/18/2006 9:19:59 AM    Re: Create and customize axis on all sides of charts
You can very easily add the secondary series that has two points: the 
 
maximum X and Y and the minimum X and Y, then hide the points. If the axes 
 
are scaled automatically, then the opposite pairs will match up. 
 
If you have to hack at the chart to get additional custom axes, you will 
 
continue to have to do so. The only apparent improvements to charts in Excel 
 
2007 are in the ability to use more colors and fill effects than ever 
 
before. 
 
- Jon 
 
------- 
 
Jon Peltier, Microsoft Excel MVP 
 
Tutorials and Custom Solutions 
 
http://PeltierTech.com 
 
_______ 
 
"Nicholas" <Nicholas@discussions.microsoft.com> wrote in message 
 
news:B1D203A6-40D2-4281-BEB0-1C8E723CE712@microsoft.com...