Set chart axis title within Macro

Try this:

ActiveChart.SeriesCollection(1).XValues = Worksheets("Sheet1").Range("Titles")

Change the name of the worksheet as applicable.

It works fine in Excel 2003

Hi se1429,

That will set the axis labels to the range defined by the named range Titles but it will be a static link.

If the range Titles changes the chart will not update.

Hi

I tried changing some cells within the range, and chart got updated on the spot.
May be you have to setup some other chart properties. I am not sure. I hope I could give an immediate answer.

Regards.

Yes, if you change any of the existing cells in the range then yes the chart will update.

I was thinking, maybe too much , that the range was dynamic, in that it could expand or contract.