Thread: Automatic repositioning data labels subset when chart updates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Automatic repositioning data labels subset when chart updates
Hi,

Can you use a second series to hold the data label positions

This example do last point and Min/Max but can be adapted to do
first/middle/last.
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

igottaknow wrote:
Several Excel charts. 25-month period. Each month a data point. Only 1st,
middle and last data points labeled. As data is updated each month, the data
labels do not shift up/down with the new first, middle, last data points.
Manual repositioning is time consuming.

Can the data labels be made to automatically shift with the chart line? If
so, can they also be forced to remain within the plot area?

I'm using Excel 2002 (10.5815.4219) SP-2

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote