I have sets of data and I want to set the horizontal (Date) axis and the vertical axis Maximums and Minimums of scatter charts to cell values I have calculated. I have not been able to make it work consistently.

I have a few questions:

1. What is the VBA code that will set the Axes limits of scatter charts to cell values?

2. On the Code page at the top, I assume I should select Worksheet. What Procedure (upper right) should I use? Why?

3. If macros are off for some reason, I can turn them on when the workbook is first opened. How can I make sure macros are on and set them if they are not?

Thank you,