I'm trying to automatically create a chart in VBA. I get all the data in correctly, but when I go to format the x and y axis labels they appear as the same thing when I record the macro.

For Example:

Please Login or Register  to view this content.
Excel always puts in the y-axis value first, then copies over that value with the next one in the code. Which leaves the x-axis still as the default value.

Any help with this would be much appreciated.

Thanks