Forum Discussion

Martin Kotuľák's avatar
Martin Kotuľák
Copper Contributor
Dec 30, 2017

Graphs in excel

Hello, I have problems with graphs in the excel.

When I create them in the same sheet as the tables from what I made it, it's ok, but if I choose to move it to a new sheet it gets to a little square and looks like this: https://imgur.com/a/YHdZi

 

But it's supposed to look like this: https://imgur.com/a/y3ax8

 

Any suggestions on what's wrong and how can I fix it? Thanks.

  • IngeborgHawighorst's avatar
    IngeborgHawighorst
    Jan 02, 2018

    Hello,

     

    check that your computer has a valid printer installed and set as the default printer. If a chart sheet in Excel does not display correctly, that is often related to the default printer settings. If you don't have a default printer installed on your computer, select the "Microsoft Print to PDF" option as the default.  

     

    If a default printer is configured, check the default paper size and margins and ensure that they are set to A3 or Letter (depending on your country) and reasonable margins.

     

    Let me know if that helps.

  • Salah Osman's avatar
    Salah Osman
    Copper Contributor

    I believe you are not copying it properly, try to copy the graph using Ctrl+V, then paste Ctrl+C, in the new sheet. it will be exactly the same graph, if I understood your question properly. 


    Martin Kotuľák wrote:

    Hello, I have problems with graphs in the excel.

    When I create them in the same sheet as the tables from what I made it, it's ok, but if I choose to move it to a new sheet it gets to a little square and looks like this: https://imgur.com/a/YHdZi

     

    But it's supposed to look like this: https://imgur.com/a/y3ax8

     

    Any suggestions on what's wrong and how can I fix it? Thanks.


     

    • Martin Kotuľák's avatar
      Martin Kotuľák
      Copper Contributor

      This screens are from an old work that I've seen, now I can't open it and even made new graphs in new sheets. It's like pressed into a little square.

      • IngeborgHawighorst's avatar
        IngeborgHawighorst
        MVP

        Hello,

         

        check that your computer has a valid printer installed and set as the default printer. If a chart sheet in Excel does not display correctly, that is often related to the default printer settings. If you don't have a default printer installed on your computer, select the "Microsoft Print to PDF" option as the default.  

         

        If a default printer is configured, check the default paper size and margins and ensure that they are set to A3 or Letter (depending on your country) and reasonable margins.

         

        Let me know if that helps.

Resources