Hi,

You need to select the line series and then select a single point before
displaying the format dialog and enabling data labels.

Cheers
Andy

NYBoy wrote:

I like to change line graph settings so that only one value will appear
on the line (not all the values).
I right clicked on the point on the line, selected format data series,
selected Data Labels tab, checked box Show Values. and then click ok.
All the data values show up on the line. But, I like to see only one
specific value. How do we do that?


---
Message posted from http://www.ExcelForum.com/


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info