+ Reply to Thread
Results 1 to 3 of 3

Values i want on the X and Y axis are plotting as 2 lines

  1. #1
    Registered User
    Join Date
    02-13-2023
    Location
    NSW, Australia
    MS-Off Ver
    2108
    Posts
    12

    Post Values i want on the X and Y axis are plotting as 2 lines

    Hi, i want to graph thickness versus mass for 2 different materials (2 data points each) which seemed pretty straightforward.

    For some reason it is graphing thickness and mass as the data lines instead of the 2 materials or plots the data points each as a separate line.
    Tried selecting the data manually but as the Y axis isn't a constant it isn't working. Do you need to have a constant for the 2 materials for the graph to calculate correctly?

    Any help would be greatly appreciated, thanks
    Attached Files Attached Files

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

    Re: Values i want on the X and Y axis are plotting as 2 lines

    Your charts are line charts, which will have a categorical horizontal axis rather than true numeric.

    I added a xy-scatter chart and then used the Select Data dialog to select the correct ranges for the x and y values.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-13-2023
    Location
    NSW, Australia
    MS-Off Ver
    2108
    Posts
    12

    Re: Values i want on the X and Y axis are plotting as 2 lines

    Thank you!

+ 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. [SOLVED] Plotting repeated values on X axis and different values on Y axis
    By jmasanganise in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-12-2018, 12:28 PM
  2. Plotting values on chart using full x-axis
    By badeend in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-12-2017, 09:45 AM
  3. Replies: 2
    Last Post: 06-19-2017, 04:51 AM
  4. Plotting multiple lines on a graph with different x values
    By freedom4horses in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2011, 04:27 PM
  5. Plotting: Offsetting series with same x axis values
    By x12179x in forum Excel General
    Replies: 1
    Last Post: 09-10-2011, 07:19 AM
  6. Plotting 2 bars and 2 lines in a 2 y-axis graph
    By patricia.junkes in forum Excel General
    Replies: 2
    Last Post: 07-08-2011, 03:33 AM
  7. Plotting values in order on x-axis
    By YYM in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-10-2008, 10:41 AM

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