How to plot values based on x, y coordinates
I hope someone can assist... I am trying to plot points on a graph based on x and y values easily. See the attached. I am essentially wanting to show the point where the two values meet and drop a "dot" or data label in that spot. Hopefully my explanation makes sense. I'm sure there's an easy way that I am just overlooking. Thank you all !
Your sample shows in cell charting. Are you required to use in cell charting techniques for this, or could you use a built in XY scatter chart (select E12:F17 -> Insert Chart -> Scatter chart or whatever that looks like in your version of Excel)? https://support.microsoft.com/en-us/...rs=en-us&ad=us
Originally Posted by shg
That worked! I was selecting column D as well because I wanted the letters in those Data Labels. I went in Label Options and did this afterwards by selecting that range. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks