Marking a particular data point in Excel

idesign73 · Oct 14, 2003

I have a graph in Excel. I have turned the markers for the data points off, as I just want to be able to view the line itself. I do, however, have two critical data points that I want to highlight or mark somehow. I envision the data point circled, or a leader coming from the data point, something to set it off so I can point out where that point is. Does anyone have any idea how to do this? I have 200 data points, so I don't want all my markers on, just two of them.
Thanks!

IRstuff · Oct 14, 2003

Select the curve and then click on the point and format that particular point. You can get markers to turn on for any individual point(s), although they have to be done one at a time.

TTFN

idesign73 · Oct 15, 2003

Thanks IRstuff, worked great.
I didn't realize you could click on a single point, whenever I tried, it would select the entire line.

IRstuff · Oct 15, 2003

It's a blessing in disguise; I often wind up selecting a point when all I want is the line.

TTFN

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Marking a particular data point in Excel

idesign73

Mechanical

IRstuff

Aerospace

idesign73

Mechanical

IRstuff

Aerospace

Similar threads

Part and Inventory Search

Sponsor