If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can a value axis autoscale to something other than 0 for the min?
I know how to manually change the scale on a value axis, but is there a way
to have the autoscale function automatically maximize the data in the chart? This is for a dynamic chart that can change when certain selection items are chosen from drop-down menus. For example, one set of data ranges from 6 to 9, so I would want the scale to be 5 to 10. Then, the selections change, and the data displayed in the chart now ranges from 31 to 39. I want the scale to be 30 to 40, not 0 to 40. Can this be done? |
#2
|
|||
|
|||
Can a value axis autoscale to something other than 0 for the min?
Unfortunately, Excel's axis autoscale algorithms do not suit your (or my)
preferences. The minimum scale will only NOT be zero if the data spans positive and negative numbers, or if the minimum is greater than (about) 65% of the maximum. If you can write your own algorithms to calculate axis limits, you can put these formulas into worksheet cells, then use VBA to link the axis to these cells, using this technique: http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jthimagesolutions" wrote in message ... I know how to manually change the scale on a value axis, but is there a way to have the autoscale function automatically maximize the data in the chart? This is for a dynamic chart that can change when certain selection items are chosen from drop-down menus. For example, one set of data ranges from 6 to 9, so I would want the scale to be 5 to 10. Then, the selections change, and the data displayed in the chart now ranges from 31 to 39. I want the scale to be 30 to 40, not 0 to 40. Can this be done? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
how to add a second x axis with same Y axis value in one plot | Mike | Charts and Charting | 1 | October 19th, 2005 08:42 AM |
Autoscale Y axis in Graph | Tim B | General Discussion | 1 | September 28th, 2004 03:57 PM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |
Logarithmic X Axis in PivotChart. | Nashhol | Charts and Charting | 0 | October 21st, 2003 04:39 PM |