+ Reply to Thread
Results 1 to 2 of 2

Plot points using the charts function

  1. #1
    Registered User
    Join Date
    01-11-2018
    Location
    Toronto, Ontario
    MS-Off Ver
    365
    Posts
    1

    Plot points using the charts function

    I am trying to plot points in excel using the charts function. I want it to place the point to scale along the X axis.

    Right now using charts excel plots the points based on an X,Y number but doesn’t put them in to scale. i.e. if I want to plot the following 3 points.

    Pt. 1 = (1,0)
    Pt. 2 = (1.2,5)
    Pt. 3 = (2,10)

    Excel currently places a straight line chart that has no kink because it is placing Pt 2 equal distant from Pt 1 and Pt3 when in reality it is only 0.2 from Pt 1 and it is 0.8 from Point 3. Is there a way to have Pt 2 place at its actual location and show up as 0.2 from point 1 so that it is to scale?

    Thanks.

    Kim.

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

    Re: Plot points using the charts function

    You don't say what chart type you are using. I would guess that you are using a line chart (category axis). It sounds like you want an XY scatter chart. This is written for 2003 and earlier, but the basic ideas still apply to later versions: https://peltiertech.com/line-charts-vs-xy-charts/ the only differences would be in the changes to the user-interface over the years/versions.

    Try using an XY scatter chart and see if that gives the desired result.
    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. How to plot points on a X-Y axis
    By veritas100 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-21-2015, 06:45 PM
  2. ReFormatting points to lines in XY scatrer charts with 6 charts on each tab.
    By Niedermee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2014, 01:51 PM
  3. Plot points on a area chart or plot areas on a scatter chart
    By maggy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2012, 04:39 AM
  4. Plot selected points only
    By callrecall911 in forum Excel General
    Replies: 1
    Last Post: 02-12-2009, 05:53 AM
  5. [SOLVED] How to plot missing points
    By Intellihome in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2005, 07:05 PM
  6. Can I plot XYZ points in excel?
    By dgs348 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-01-2005, 05:05 PM
  7. Plot points with same x-value in same series?
    By smKing in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2005, 04:06 PM

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