+ Reply to Thread
Results 1 to 6 of 6

Creating Graphs

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Creating Graphs

    I'm trying to create a single 'line type' chart from two sets of data. The 'x' axis for both is the distance along carriageway, the 'y' data are values of skidding resistance. The problem is that the two sets of data are recorded at different locations on the carriageway and when I try to join the data sets there are gaps in the lines. e.g.

    Distance (x) Data Set 1 'y1' Data Set 2 'y2'
    100 2 2
    125 1
    150 2
    175 3 2
    200 2
    225 3
    250 1 1

    And so on, is there a way to create a 'line type' chart without gaps in the lines where there are gaps in the data?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Creating Graphs

    Try filling the gaps with =NA()

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Creating Graphs

    I think if you change the blanks to errors by using a helper column with the formula:

    =IF(C3="",NA(),C3)

    and link the graph to this column instead of the third column, then excel will ignore the errors completely and your graph should look all pretty.

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

    Re: Creating Graphs

    Hello,

    if you want to connect all data points, select the chart, then click Tools > Options > Chart tab > Interpolate.

    see attached.

    cheers
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-15-2011
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Creating Graphs

    Thanks very much everybody, all three seem to work.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: Creating Graphs

    You're welcome.

    If these solutions address your problem, please mark the thread as solved.

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

    Regards

+ 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