Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data range blank in Excel (2000)

    Can someone tell me how l produce a graph from excel but some for odd reason the space is blank in the data range.
    see screenshot.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data range blank in Excel (2000)

    I'd start by removing the blank rows in between the data.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Data range blank in Excel (2000)

    With the blank rows and only a line plotted, there are no lines to plot since none of the points connect. Change to markers and you will see the points.

    Steve

  4. #4
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data range blank in Excel (2000)

    thanks

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Data range blank in Excel (2000)

    Another option if you don't want to remove the blanks:
    tools - options - chart(tab)
    select "Plot empty cells" as "interpolated"

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •