| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Charts
I have a chart that I would like for the y-axis to scale automatically when
new numbers is entered into the series. How do I set this up? -- Sandi Gardner |
|
#2
|
|||
|
|||
|
The default setting will cause XL to automatically scale the axis. To
control the min/max values it is necessary to use VBA code. For a readymade solution see AutoChart Manager http://www.tushar-mehta.com/excel/so...art/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have a chart that I would like for the y-axis to scale automatically when new numbers is entered into the series. How do I set this up? |
|
#3
|
|||
|
|||
|
Sandi,
In addition to Tushar's add-in, you can find an example of the VBA code used to set the axis he http://www.pdbook.com/index.php/excel/tie_y_axes/ ---- Regards, John Mansfield http://www.pdbook.com "Sandi" wrote: I have a chart that I would like for the y-axis to scale automatically when new numbers is entered into the series. How do I set this up? -- Sandi Gardner |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
| i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
| How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
| initial size of new charts | Charts and Charting in Excel | |||
Hybrid Mode
