Excel 2007 - How to specify chart min in VBA
Posted on 2011-02-11
I have an Excel page with two scatter graphs and I need to specify the vertical axis min to equal a value calculated in a sheet cell.
I am having trouble specifying the component and property to change. I am a beginner in VBA. I can get to the code page for the sheet that contains the graphs but I can find to reference to the graphs or their properties. In some online material it mentions a column on the right which I think contains the info I want, but I have no such column when looking at the code page.
I could use help in two ways: 1) Tell me the code to write to specify the minimum for each of two graphs on one page and 2) Help me navigate the UI to find graphs and properties myself.