Create and customize axis on all sides of charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/com...8e723ce712&dg=microsoft.public.excel.charting
 
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
 
Back
Top