+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : XY Scatter Chart - Line format problem

  1. #1
    Registered User
    Join Date
    05-12-2009
    Location
    Udevalla, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    85

    XY Scatter Chart - Line format problem

    Hey guys.

    Is it possible in Excel 2007 to get a chart where the line looks like the line in the picture attached? That particular chart was made in Excel 2003.
    I have a list of x and y co-ordinates that I am using as data series but all I can get is a smooth line connecting the points.

    Any help is appreciated. I have been trying to get this to work for hours.
    Attached Images Attached Images
    Last edited by Carlsbergen; 10-21-2011 at 06:19 AM.

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

    Re: XY Scatter Chart - Line format problem

    uncheck the plot smooth line option on the Format data series dialog.

    If you have a true xy-scatter chart and each point is defined xl2007 chart will the steps in the line.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: XY Scatter Chart - Line format problem

    Hello,

    What's your data? For straight lines like this, you will need suitable data for the data points.

    See attached.

    cheers,
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-12-2009
    Location
    Udevalla, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: XY Scatter Chart - Line format problem

    Quote Originally Posted by teylyn View Post
    Hello,

    What's your data? For straight lines like this, you will need suitable data for the data points.

    See attached.

    cheers,

    Ah yes. Here was the solution.
    I didnt have my data properly formated.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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