The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel Sheet *Where's the lines come from ?*

    Discussion in 'Windows OS and Software' started by Halloween, Jan 30, 2009.

  1. Halloween

    Halloween Notebook Enthusiast

    Reputations:
    5
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    15
    Hello,

    Does anyone know about this issue in Excel sheet ?

    On my graphic charts, I see 2 lines that appeared out of no where and I can't do anything about it.

    I tried editing the "Borders". Did not help.
    When I print my chart, the lines does show.
    There's an example on the "Attached Thumbnails".

    I'm @ work using Microsoft Office Professional Edition 2003 SP3 with Windows XP Professional SP2.

    Any help woud be appreciated.

    Thanks!
     

    Attached Files:

    Halloween, Jan 30, 2009
    #1
  2. Wishmaker

    Wishmaker BBQ Expert

    Reputations:
    379
    Messages:
    1,848
    Likes Received:
    35
    Trophy Points:
    66
    Isn't that a page split?
     
    Wishmaker, Jan 30, 2009
    #2
  3. HerrKaputt

    HerrKaputt Elite Notebook User

    Reputations:
    444
    Messages:
    2,510
    Likes Received:
    0
    Trophy Points:
    55
    Have you tried copying the data to a new spreadsheet, remaking the chart and checking whether the lines still appear? If they don't appear anymore, it might not be worth further worrying (although it's not really a solution, more a workaround).
     
    HerrKaputt, Jan 30, 2009
    #3
  4. kanehi

    kanehi Notebook Deity

    Reputations:
    146
    Messages:
    1,943
    Likes Received:
    0
    Trophy Points:
    55
    Yup it looks like a page split..double lines across the page. Have to fit the chart on the page. Have you done 'print preview'?
     
    kanehi, Jan 30, 2009
    #4
  5. Halloween

    Halloween Notebook Enthusiast

    Reputations:
    5
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    15
    Thanks for the fast replies :)

    Sorry, don't know what is page split ?

    Yes, I did copied data from another spread sheet.
    My work is to enter stats for every months. So I just copy the file, change the name of the file & add new stats.

     
    Halloween, Jan 30, 2009
    #5
  6. Wishmaker

    Wishmaker BBQ Expert

    Reputations:
    379
    Messages:
    1,848
    Likes Received:
    35
    Trophy Points:
    66
    By Page Split I mean...

    Page Layout ->Margins...
     
    Wishmaker, Jan 30, 2009
    #6
  7. Halloween

    Halloween Notebook Enthusiast

    Reputations:
    5
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    15
    Yup, just did print preview and it does not show the double lines.
    So far, I just right click on my chart and selected "Bring to front", it's doing the job for now :)

     
    Halloween, Jan 30, 2009
    #7
  8. Halloween

    Halloween Notebook Enthusiast

    Reputations:
    5
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    15
    I had to change the "Margins" to be able to fit in 1 page.

     

    Attached Files:

    Halloween, Jan 30, 2009
    #8
  9. surfasb

    surfasb Titles Shmm-itles

    Reputations:
    2,637
    Messages:
    6,370
    Likes Received:
    0
    Trophy Points:
    205
    Yup, that sure is a page split. I thought that was normally turned off by default.
     
    surfasb, Jan 30, 2009
    #9
  10. Halloween

    Halloween Notebook Enthusiast

    Reputations:
    5
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    15
    Thanks for the help eveyrone!

    It's working good! *Thumbs up*
     
    Halloween, Jan 30, 2009
    #10