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
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.
- 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.
- 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.
- Entering a more descriptive name to replace "Chart1."This step is especially useful if you plan to have multiple chart sheets in the workbook.
- Click OK to close the Move Chart dialog box.
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!
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.
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
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.
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.
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!
- Proposed as answer by TheBigSchtroumpf Monday, August 22, 2011 10:37 PM
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
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
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.
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