I'm using Excel 2010
I have a table of data and a scatter chart depicting the data.
Upon activating a macro the data cycles based on some specified information. This animates the chart.
Is there a way to specify the axes values for the "x" and "y" axes in the chart without going through the entire process of opening the Chart Tools and specifying the values? I want to use the "fixed" values that I specify. I would like to specify each minimum and maximum value in a cell and have the chart axes adjust accordingly.
I have a table of data and a scatter chart depicting the data.
Upon activating a macro the data cycles based on some specified information. This animates the chart.
Is there a way to specify the axes values for the "x" and "y" axes in the chart without going through the entire process of opening the Chart Tools and specifying the values? I want to use the "fixed" values that I specify. I would like to specify each minimum and maximum value in a cell and have the chart axes adjust accordingly.
