Hi folks
I've got a macro which loops through data and creates a new chart for each set, however I'm having problems with getting axis titles on to the charts - the code runs correctly and creates the charts, but I don't seem to be able to get any axis titles to show.
I've tried three differing codes to try to add the x-axis title, but it's just not happening.
This is what the macro recorder (Excel 2010) shows me for adding the axis title - but it remains blank with this code too.
Could it be because I'm using pre-set formatting of ChartStyle? Does that not allow for axis titles to be added?
Thanks in advance.
Bookmarks