Excel Chart: Change data label using VBA?

[rlee16]

Is there a way to use VBA to automate the process of updating data labels (for a series not a data point) on an excel chart?

I have a line chart graphing a time series. I also have horizontal lines for max, standard deviation, average, and min. These are labeled as such: max1.88x, 1sd1.36x, avg0.83x, -1sd0.62, and min0.41x.

However, these labels must change every day to reflect new data. Thanks for the help.

Richard

 

[SkipVought]

Richard,

Select you chart -- right click, selecting data source - series tab.

In the series tab, list box lists each series.

Each series has

Name -- Series label
Values -- y-axis data range
Categories - x-axis data range

So on your SHEET you can change the series label and it will be reflected in your chart -- if you have a Legend, for instance.

BTW, your data ranges can be defined to be DYNAMIC using the OFFSET function as described in faq68-1331 How can I rename a table as it changes size

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884