+ Reply to Thread
Results 1 to 6 of 6

How do I add a numerical series of values to a chart over the X-axis but without the line?

  1. #1
    Registered User
    Join Date
    03-21-2015
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    16

    Question How do I add a numerical series of values to a chart over the X-axis but without the line?

    I have a chart displaying two fitted curves.

    I would like to add a third series that would consist of just the Y data values of the third series displayed just above the X-axis but with no line or line markers.

    I can't just change the line color to "white" and display the Y values next to the hidden data points, as the text labels would end up outside the visible area of the chart.

    I need the Y-values of the series to be printed just above the X-axis.

    It needs to look like this where the two curves are my series 1 and 2, and the text turned 90 degrees would be the Y-values from series 3.

    excel chart.JPG
    Last edited by jerbes; 03-27-2015 at 04:26 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: How do I add a numerical series of values to a chart over the X-axis but without the l

    can you post example file of what you currently have.

    you can add a series and plot the points wherever you need them and then link the data labels to cells which contain the data to be displayed.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-21-2015
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    16

    Re: How do I add a numerical series of values to a chart over the X-axis but without the l

    The file is attached. Refer to the chart on Sheet2.
    The data I would like to add to the chart would be J35 - J114.
    I would like to add these values as text just above the X-axis.

    It's not clear to me as how I would "link the data labels to cells which contain the data to be displayed"

    Thanks for looking at this.
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How do I add a numerical series of values to a chart over the X-axis but without the l

    see attached step by step instruction. Final touches left for you
    Attached Files Attached Files
    Best Regards,

    Kaper

  5. #5
    Registered User
    Join Date
    03-21-2015
    Location
    Milwaukee
    MS-Off Ver
    2010
    Posts
    16

    Re: How do I add a numerical series of values to a chart over the X-axis but without the l

    Kaper, thank you for the step-by-step instruction.
    A very elegant solution to the problem.

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: How do I add a numerical series of values to a chart over the X-axis but without the l

    You are welcome
    Thanks for marking thread solved, and for the reputation.

+ 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. Bubbel Chart with non-numerical values for both X axis and Y axis
    By air15567 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-29-2014, 11:25 AM
  2. Multi Line Graph with series that have inconsistent X axis values
    By potejam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-08-2013, 07:20 PM
  3. RE: Moving X Axis and Series Values in chart
    By statsfun in forum Excel General
    Replies: 0
    Last Post: 09-13-2012, 11:41 AM
  4. Replies: 0
    Last Post: 06-27-2012, 04:16 AM
  5. Replies: 1
    Last Post: 05-07-2012, 11:53 AM

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