+ Reply to Thread
Results 1 to 6 of 6

lose some information on print outs of Excel charts

  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    34

    lose some information on print outs of Excel charts

    Hi There

    I lose some information on print outs of Excel charts. Information is not lost on the print out when I copy and past special the Excel charts into JPEG, GIF, PNG or Enhanced Metafile pictures. However the formatting on the print out does not always match that of the table data which I'm charting.

    How can I ensure that the font LOOKS similar?

    Cheers



    Michael

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: lose some information on print outs of Excel charts

    Hi Michael
    In order to advise we would need to see a copy of your workbook so we can check the print settings etc. Only then can we advise clearly.
    Tony

  3. #3
    Registered User
    Join Date
    07-04-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: lose some information on print outs of Excel charts

    I have attached the report here

  4. #4
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: lose some information on print outs of Excel charts

    Hi Michael
    Thanks for posting a sample. When I print I only lose the last line of the page initially. I then chose to change the print settings to print on one page and it works fine.
    Your issues appears to be with your printer settings. Check that you have the option to change the print settings to print on one page and see if that resolves your issue.
    Good luck.
    Tony

  5. #5
    Registered User
    Join Date
    07-04-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: lose some information on print outs of Excel charts

    Thanks Tony

    Sorry! I'm re-attching the file but this time with the chart shown as a picture embedded object. The issue is not losing data just that font for the embedded object does not alawys match that of the data being charted



    Cheers

    Michael

  6. #6
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: lose some information on print outs of Excel charts

    Hi Michael
    Try printing it to a pdf file. I have tested it and the font looks exactly the same.
    Hope this helps.
    Tony

+ 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. Muliple print outs from one proforma
    By rhino4eva in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2012, 04:17 AM
  2. Excel 2007 : Hidden Data Showing On Print Outs
    By The_Snook in forum Excel General
    Replies: 3
    Last Post: 01-10-2012, 10:02 AM
  3. Replies: 1
    Last Post: 04-23-2011, 12:49 PM
  4. Replies: 0
    Last Post: 11-05-2010, 01:24 PM
  5. Words are duplicated in print-outs
    By agentred in forum Word Formatting & General
    Replies: 2
    Last Post: 07-14-2010, 10:43 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