Dear All,
I have produced a graph in Excel where the x axis values vary as per a function in the worksheet when I move a slider.
As the values move the graph modifies. I need the scale of the axis to modify too.
The graph is also plotting a circle, so I also need the Y axis to update in proportion. The Y value is a constant so basically the scale needs to change in proportion as the x axis scale changes in order to maintain a circular shape to the graph.
Any ideas much appreciated.
Chris
ps I've never written a macros and I'm not farmiliar with VB.
I have produced a graph in Excel where the x axis values vary as per a function in the worksheet when I move a slider.
As the values move the graph modifies. I need the scale of the axis to modify too.
The graph is also plotting a circle, so I also need the Y axis to update in proportion. The Y value is a constant so basically the scale needs to change in proportion as the x axis scale changes in order to maintain a circular shape to the graph.
Any ideas much appreciated.
Chris
ps I've never written a macros and I'm not farmiliar with VB.
