Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link a cell to min & max box for Value (X) axis scale?
I want to update the min and max box of the Value (X) axis scale without
having to click on the axis, select the tab and type in the min and max times for each scale for each chart. Can I assign a cell in the spreadsheet so that its value will be used in the min and max boxes? Does anyone have a suggestion on how to best accomplish this? Thanks, |
#2
|
|||
|
|||
You have to do this programmatically. 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 want to update the min and max box of the Value (X) axis scale without having to click on the axis, select the tab and type in the min and max times for each scale for each chart. Can I assign a cell in the spreadsheet so that its value will be used in the min and max boxes? Does anyone have a suggestion on how to best accomplish this? Thanks, |
#3
|
|||
|
|||
I had just found the Autochart manager and installed the add-in. I found a
link from J. Peltair's site to yours. Great add-in! I would like to be able to specify the major increments also. "Tushar Mehta" wrote: You have to do this programmatically. 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 want to update the min and max box of the Value (X) axis scale without having to click on the axis, select the tab and type in the min and max times for each scale for each chart. Can I assign a cell in the spreadsheet so that its value will be used in the min and max boxes? Does anyone have a suggestion on how to best accomplish this? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Page field link to cell | Excel Worksheet Functions | |||
Insert cell into link | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions | |||
Link the value to text in a cell, then use that text cell in a for | Excel Worksheet Functions | |||
I am trying to link based on a text value instead of cell position | Links and Linking in Excel |