+ Reply to Thread
Results 1 to 2 of 2

How to display the value of y variable on selected points of the chart in excel 2016

  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    Lisbon
    MS-Off Ver
    2016
    Posts
    3

    How to display the value of y variable on selected points of the chart in excel 2016

    Hello,

    I am doing a 2 variable chart (y vs x) in excel 2016. I want to display the value of the y variable at some points of the curve, next to the point. How can I do that?

    Many thanks in advance,
    Best regards,
    Miguel

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How to display the value of y variable on selected points of the chart in excel 2016

    I see a couple of different possibilities -- all of them involving data labels: https://support.office.com/en-us/art...2-f467c9f4eb2d

    1) If you know now which points you want to label and those points will never change, then select those points and add data labels to just those points (I assume 2016 will still allow you to add data labels to individual data points the way 2007 will).

    2) If you want more flexibility, place the desired points to label in a separate area of the spreadsheet and add those points as a separate data series. Then add data labels to that data series. Then, when you need to change which points are labeled, you can simply edit the points of this data series.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  2. Excel 2016 VBA Statusbar display does not work
    By ArnabKGhosal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2016, 12:29 PM
  3. Scattered Chart - Adding Data Labels to selected points
    By marcinpec in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2016, 02:57 PM
  4. Replies: 2
    Last Post: 06-19-2012, 07:48 AM
  5. Moving an Excel chart's data points (Variable Problem)
    By AliJay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2010, 03:51 AM
  6. [SOLVED] Lock Chart Display to last 14 days (or data points)
    By toilinthedark in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-21-2005, 01:05 AM
  7. Replies: 1
    Last Post: 08-03-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1