| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there way I can automatically have Excel change the scale om a.
I have an excel file, which I uses to make xy graphs but I change the value
that are plotted. The graph does not rescale by itself so I have to keep on doing it manually. Is there a way to get Excel to automatically rescale? |
|
#2
|
|||
|
|||
|
Jon Peltier has a couple of techniques that you could use:
http://www.peltiertech.com/Excel/Cha...nkToSheet.html Phil wrote: I have an excel file, which I uses to make xy graphs but I change the value that are plotted. The graph does not rescale by itself so I have to keep on doing it manually. Is there a way to get Excel to automatically rescale? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
For a ready-made 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 an excel file, which I uses to make xy graphs but I change the value that are plotted. The graph does not rescale by itself so I have to keep on doing it manually. Is there a way to get Excel to automatically rescale? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Setting today's date automatically in Excel. | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
| Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
Linear Mode
