+ Reply to Thread
Results 1 to 4 of 4

Plotting Line Graph for data with lots of gaps

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    raleigh USA
    MS-Off Ver
    2010
    Posts
    2

    Plotting Line Graph for data with lots of gaps

    Hi, I am trying to plot a line graph for data that has gaps. The rows can go upto 5000+ with lots of cells left empty in-between. When I try to select the entire range of 5000 cells I get a weird graph thats trying to accomodate all the empty values (even when I edit the hidden/empty cells settings to gaps-zero-connect data with lines). I just care about the values that exist. Here's an example of my data:

    S.No.......(columns in-between).......Data1
    1................................................40
    2................................................30




    6................................................22
    7................................................30


    I want S.No (1,2,6,7) on x-axis & Data1 (intervals of 5 or 10) on y-axis. Also, I have to show 2 plots for tolerances on the same graph (ex: tolerance of +/-3% of 40). Thank you so much for any suggestions.

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

    Re: Plotting Line Graph for data with lots of gaps

    You need to hide those rows. You can use Autofilter to do that.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-21-2014
    Location
    raleigh USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Plotting Line Graph for data with lots of gaps

    Thanks for your reply Andy. Since the data has other columns its not possible to hide the rows.

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

    Re: Plotting Line Graph for data with lots of gaps

    The you will need to build a contiguous set of cells using formula or code which you can chart.

+ 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. Graph starts with plotting #N/A as gaps
    By joewonga in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2013, 04:04 AM
  2. Plotting Mean and SD on the same Line graph
    By Katherine133 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-17-2012, 07:11 PM
  3. Plotting complex data to a line graph
    By bootydaddy73 in forum Excel General
    Replies: 1
    Last Post: 09-27-2011, 09:41 AM
  4. Plotting Cummulative Data In A Line Graph
    By tkeith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-10-2006, 08:40 PM
  5. Plotting Line Graph of Dynamic Data
    By sslack in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2005, 11:05 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