If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Display Name of each 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 On 19/02/2010 06:08, kkgupta wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|