Automatically update Value for data label

N

Nav

Hello

I am using Excel 2003 SP2, and have some graphs which have the value (data
label) for the last month. Each month new data is entered and the data label
has to be deleted for the previous month and the data label for the most
recent month added (it still uses the same old data - new data is only
entered for the most recent month).

Is there any way where the data label can automatically update with the most
recent months value (as the chart updates itself automatically currently).

Any ideas appreciated. Thank you in advance.

Regards,
Nav
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Dynamic stacked bar chart not working 3
Dsum and Dmax with structured references 1
Formatting of Data Labels in Histograms 4
Line graphs in Excel 2007 6
Automatic repositioning data labels subset when chart updates 3
Automate data labels 3
Macro to change position of chart labels on line chart 1

Top