View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
kkgupta kkgupta is offline
external usenet poster
 
Posts: 1
Default Display Name of each Data Series

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.