T
Tom
I'm sure this is a standing suggestion, but I thought I would add it again.
In addition to Auto and Fixed options for setting the Minimum and Maximum
Values on an axis, there needs to be one that would allow the user to use a
value in a cell. There are two specific use cases where this would be most
helpful:
A. You want the range of the axis to be the minimum and maximum values
plotted for a selected data series. This would be easily accomplished by the
following:
A1. Create the data series.
A2. Create cells containing the Min() and Max() values.
A3. Selecting the data for the series.
A4. Selecting the Min() and Max() cells as the Minimum and Maximum of the
chart.
B. You have multiple charts based on several sets of data, and you want them
all to use the same range (e.g., 0-100 for multiple charts with percents).
This would be accomplished by the following:
A1. Enter the chart Minimum and Maximum values you want to use in a cell.
A2. Select these cells in each chart as the Minimum and Maximum of the chart.
Thanks.
----------------
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...552987cd9f&dg=microsoft.public.excel.charting
In addition to Auto and Fixed options for setting the Minimum and Maximum
Values on an axis, there needs to be one that would allow the user to use a
value in a cell. There are two specific use cases where this would be most
helpful:
A. You want the range of the axis to be the minimum and maximum values
plotted for a selected data series. This would be easily accomplished by the
following:
A1. Create the data series.
A2. Create cells containing the Min() and Max() values.
A3. Selecting the data for the series.
A4. Selecting the Min() and Max() cells as the Minimum and Maximum of the
chart.
B. You have multiple charts based on several sets of data, and you want them
all to use the same range (e.g., 0-100 for multiple charts with percents).
This would be accomplished by the following:
A1. Enter the chart Minimum and Maximum values you want to use in a cell.
A2. Select these cells in each chart as the Minimum and Maximum of the chart.
Thanks.
----------------
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...552987cd9f&dg=microsoft.public.excel.charting