I maintain a variety of line charts that are plotted over time. On every chart, for the last data point I have plotted, I have a data label with the corresponding value display. However, every time I update a chart with a new data point, a subsequent new data lablel is generated for that point. I then have to go back to the chart and delete the prior months label so that only the new month's data label shows. Is there a way to format the chart so that when a new data point is entered and a new label is made in the chart, the old label goes away so that only the new remains?
Thanks in advance!
Bookmarks