I created a macro that reforms my data and creates a chart. Teh macro also includes selecting a chart layout that has an x and y axis field that I want to enter in some text. My macro works all the way except it does not record the content I put into the X and Y axis.
Why is that? and how can i get around the problem? I want the macro to create a standard looking chart with proper x and y axis titles.