|
| 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
June 6th, 2005, 07:21 PM
|
|||
|
|||
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
June 6th, 2005, 08:47 PM
|
|||
|
|||
|
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
June 6th, 2005, 09:19 PM
|
|||
|
|||
|
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,
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy cell format to cell on another worksht and update automatical | kevinm | Worksheet Functions | 21 | May 19th, 2005 11:07 AM |
| Using paste link infromation in cell to hyperlink to source cell? | Wayne | Worksheet Functions | 7 | February 27th, 2005 07:38 PM |
| Can I copy a combo box in Excel 2002 with a relative cell link? | Bozo | General Discussion | 1 | February 17th, 2005 02:05 AM |
| I am trying to link based on a text value instead of cell position | John | Links and Linking | 3 | December 3rd, 2004 06:29 PM |
| Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Linear Mode
