none
Excel 2010 Chart will not display on its own sheet - intermittent

    Question

  • Our business has all just had Office 2010 installed. We are all finding that Excel randomly and intermittently will sometimes not display any of the charts in their own sheets. Furthermore, they can suddenly reformat into a portrait rather than landscape format. Some spreadsheets have had some charts showing while other charts are not showing.  They come and go at random each new time you open the spreadsheet. It makes using Excel impossible and we are considering going back to Office 2007 where we never experienced this issue as there seems no pattern, and therefore no way to define and fix the problem. This is affecting 80 users.

    • Changed type Sally Tang Thursday, March 10, 2011 7:39 AM
    Tuesday, March 08, 2011 4:45 PM

All replies

  • Hi,


    Excel 2010 automatically embeds new charts on the same worksheet as the source data, but you may find it easier to work with a chart if you move the chart to its own chart sheet in the workbook.

    1. On the Chart Tools Design tab, click the Move Chart button to open the Move Chart dialog box.If you don’t see the Chart Tools Design tab, select the chart to make this tab appear.
    2. Click the New Sheet option button in the Move Chart dialog box.This option places the chart on a new chart sheet that is added to the current workbook.
    3. Entering a more descriptive name to replace "Chart1."This step is especially useful if you plan to have multiple chart sheets in the workbook.
    4. Click OK to close the Move Chart dialog box.

    Best Regards,

    Sally Tang

    Thursday, March 10, 2011 7:50 AM
  • Sally -- I have the same problem, but it occurs mainly when the charts are given their own tab -- then they are invisible to me. This has made my Excel 2010 largely useless to me, since my assistant sends me excel sheets with tabbed charts and I cannot see, copy or modify them. Help!

    Ron

    Sunday, March 13, 2011 10:15 PM
  • I have exactly the same problem - in some ways I'm pleased to see I'm not the only one! This is stopping me from opening other peoples spreadsheets & also from sensibly producing new charts of my own!

    Is this a bug?

    Is there a fix for this?

    Jason

    Monday, April 04, 2011 4:09 PM
  • Slight difference here:-

    I'm running Excel 2007 on Vista. I believe I have the latest service packs / updates for all programs.

    I have been using this combination of 2007 & Vista for 2-3 yrs now, suddenly since christmas it has started falling over. I have not re-installed this software, but there may have been a windows update since then.

    Jason

    Monday, April 04, 2011 4:13 PM
  • I have been looking elsewhere for an answer & found it on another help site.

    Apparently, it's linked to PRINT PREVIEW. If you open a spreadsheet, go to the chart that won't open, view "print preview", then close this down, magically it all goes back to normal !!!!!

    Or at least it did for me!

    Good luck!   Jason

    • Proposed as answer by JM_012 Friday, May 04, 2012 1:50 PM
    Monday, April 04, 2011 4:31 PM
  • I agree that this inability to display a graph is oinnected to print preview. I run Windows 7 Professional 64 bit with Office 2010 64 bit including Excel. Making graphs is mission critical to my work. This lack of visability of graphs has been a large waste of time. It is a new phenomenon, which I believe was caused by a recent update. My MIS Manager says that once I have a working system, I should avoid updates and delay purchasing new software.

    I suspect the problem is the result of inappropriate coupling the printing and display functions. The formating can be made using the same software. However, the inability to print or preview printing should not disable the Excel display. It should also not interfere with the creation of PDFs. These systems should degrade gracefully.

    Robert C. Leif, Ph.D. 

    Wednesday, April 06, 2011 6:54 PM
  • I was having a similar problem.  I couldn't move charts from one spreadsheet to another, nor could I move the chart to it's own tab.  Worse yet, if I tried, the whole spreadsheet, data and chart, were simply deleted with no obvious way to recover if I hadn't saved beforehand.  However, when I shortened my file name, the problem went away.  This problem only appeared today, but I've only used such a long file name today.
    Thursday, April 07, 2011 7:31 PM
  • I'm having the same issue!

    Did you find any solution?

    It is really anoying and Microsift should do something!

    Monday, August 22, 2011 10:28 PM
  • Actually I just found a solution!

    This issue apears when your printer is misconfigured or, as it was the case for me, a notwork printer not availible. In theses case office is not able to make a print prview of the chart. I know that's a bit odd but it Microsoft way ;)

    I set my default printer to 'Microsoft XPS Document Printer' and now it work fine! :)

    Hope that will help!

    Monday, August 22, 2011 10:37 PM
  • HI all,

     

    I have been having similar issues but have managed to find a fix. If you remove printers, re-install then and set default  orientation to landscape it changed my graphs to the correct size and format. This may work without the removal of printers but i didn't try that first, but it may be worth trying. It is very odd as i changed default orientation the chart was changing behind to the correct format and then the incorrect format. I am thinking this must be an issue with the printer driver.

    • Proposed as answer by Jo_lo1978 Friday, October 07, 2011 8:24 AM
    Thursday, October 06, 2011 11:20 AM
  • Jason I found that the default printer was offline. This kept the charts in excel from displaying. Apparently it is connected to print preview. When I went to print preview the chart was absent, then I noticed my default printer was offline. When I made sure that my computer had a working online printer, the charts would display in print preview and also by just reopening the excel spreadsheet the charts were also dsiplayed.
    • Proposed as answer by T Hough Saturday, October 27, 2012 10:49 PM
    Friday, August 31, 2012 6:06 PM
  • Dear Moderator,

    Would you see that this is logged and resolved? It doesn't seem to be a robust solution to have the view capability for a chart object dependent on the print configuration. I experienced the same problem and am in the same boat with all present -- I need the ability to place charts in independent tabs in a spreadsheet to give my customers and bosses what they are asking for! Thank you for your concern.

    Gabe

    • Proposed as answer by JesTV Thursday, January 17, 2013 9:42 PM
    • Unproposed as answer by JesTV Thursday, January 17, 2013 9:42 PM
    Friday, September 14, 2012 2:18 PM
  • Yes - this sorted my issue out - wish I'd checked this site earlier - just spent a frustrating 4 hours trying to sort it out to be able to pdf a client's report! But thank you - problem solved

    Saturday, October 27, 2012 10:50 PM
  • If your default printer is missing, MS Office 2010 is unable to render the chart. As suggested go to Print preview and select a valid Printer if you don't have any then select Microsoft XPS Document Writer
    Tuesday, November 20, 2012 6:52 PM
  • Hi,

    Problem :

    Chart is not getting diaplayed in the excel file. It was displaying well before..

    Solution :

    There are multiple printers installed on the computer. I changed the default printer to other one & now I can see the charts in the excel file

    Thursday, July 04, 2013 8:38 AM
  • The issue is that Microsoft Office is a WYSIWYG application, meaning, they set it up so that what you see on the screen is as close a match as possible to what you see printed out.  Since different printers have different capabilities, Excel has to check in with the printer how it will print, before giving you the display on the screen. 

    If the printer is not available, then Excel cannot know how to display the chart.  I agree that it would be useful if Excel had a fallback display rendering driver, but it does not, and so certain kinds of objects that are graphics intensive are dependent on printers.

    All of the techniques that followed "setting your printer to one that is both available and functional" (close and reopen the file, go to print preview, change orientation) all call on the printer driver, so allow Excel to reset the tool used to render the chart.

    Thus, the basic steps to fix this are:

    1: Change your default printer that one that works and is available (can use the Document Imager or a print to PDF driver as a default if there are no printers available

    2: Reset the printer that excel uses by closing and reopening the file, or by going into and then leaving print preview for each chart sheet

    I did not see this information (the whys of the answer) in the other replies, so am adding it.


    • Edited by KayteCat Wednesday, October 09, 2013 1:57 PM edited for completion
    Wednesday, October 09, 2013 1:50 PM