Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting scale on chart automatically
I am having users select a time series (line) chart from a drop down menu. (I
have a bunch of data on a separate page. The drop down menu pulls in the requested data to a defined range and draws the chart). Frequently, the scale on the Y axis that Excel chooses is highly sub-optimal. I don't want the user to have to manually adjust the axes. Is there any way I can specify the scale on the axes without manual adjustments? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
setting scale on chart automatically
You could use VBA:
Link Chart Axis Scale Parameters to Values in Cells (VBA) http://peltiertech.com/Excel/Charts/...nkToSheet.html Use formulas to put "nice" scaling values into the cells monitored by the macro. - Jon ------- Jon Peltier Peltier Technical Services, Inc. 774-275-0064 http://peltiertech.com/ On 4/9/2010 3:39 PM, Sanford Lefkowitz wrote: I am having users select a time series (line) chart from a drop down menu. (I have a bunch of data on a separate page. The drop down menu pulls in the requested data to a defined range and draws the chart). Frequently, the scale on the Y axis that Excel chooses is highly sub-optimal. I don't want the user to have to manually adjust the axes. Is there any way I can specify the scale on the axes without manual adjustments? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically Scale Gantt Chart Time Scale | Charts and Charting in Excel | |||
Chart setting scale | Charts and Charting in Excel | |||
Chart not visible -suspect scale setting? | Charts and Charting in Excel | |||
Setting chart scale min/max in VBA | Charts and Charting in Excel | |||
Setting rules for y scale | Charts and Charting in Excel |