Display Name of each Data Series

  • Thread starter Thread starter kkgupta
  • Start date Start date
K

kkgupta

I have an X-Y chart with, say, 3 data series, named 2008, 2009 and 2010. I
want to get rid of the legend (by deleting it) and instead have the above
names displayed on the relevant curve. Is there a way in Excel XP (aided by
VBA) to display the name of each data series on the series itself?

If one tries: Format data series -> Data Labels -> Series Name, the Series
Name is displayed 10 times if there are 10 data points! I want it displayed
only once, somewhere in the middle of the curve representing that data series.
 
Hi,

Either, select a single point in the series and then apply data label.
Or add additional series with 1 point only. You can then position the
point/data-label where you want without messing with the actual data points.

Cheers
Andy
 
Back
Top