This Excel add-in links the minimum, maximum, major, and minor values of a chart axis to worksheet cells.
For more see http://www.tushar-mehta.com/excel/software/autochart/index.html
This Excel add-in links the minimum, maximum, major, and minor values of a chart axis to worksheet cells.
For more see http://www.tushar-mehta.com/excel/software/autochart/index.html
I wrote this morning that I can’t link charts to AutoChart. Worked fine for one chart yesterday and then hasn’t worked since. when I select a chart the fields were cell links are placed are not accessible.
Hi Brian,
The fields for the cell links for a particular axis are enabled only if the chart supports numeric values for that axis. Maybe, that is the issue with the chart you are using. Also, you may want to ensure you are using the latest version of the add-in.
Do you have a version that works on 64bit Excel 2010?
Glen, I expect to have one ready by next week.
I used the tool to reference relevant axis scale parameters to cell values, which worked well.
However, the references do not get saved. So if I want to paste new data and have new axis scale parameters I have to reference them again even though they are pasted into the same cells as before.