Search code examples
excelchartsexcel-2010diagramexcel-2013

Excel 2013 - Miniature chart bug on "move to another sheet"?


I wrote a VBA Macro a while back when I had Excel 2010 and it worked flawlessly. The result was a chart that at the end was moved to a dedicated new "diagram sheet" (so not a normal worksheet, but those ones who shows only graphic data).

Today I needed to use that macro again, I tried it on Excel 2013 and... The chart would be correctly moved to this other dedicated sheet, but it was miniaturized!

enter image description here

It was not possible to make it bigger and zooming in was of no help! I thought my Subroutine was flawed, but I had to try to move the chart manually to another sheet before... I got the same result! Closed Excel and reopened... Same result.

Now, does Excel 2013 have some stupid options set, so that those charts cannot be used, or is it a bug? ...And more important... How do I make this thing work?


Solution

  • The problem was generated by a failure of PRINTER DRIVERS (!) to cope with those "Chartsheets". I don't have a single clue of how this happens, but should you people have such problems, the only thing that will solve them is to change the printer also if you don't have to print anything. Mine in this very case was Microsoft XPS Document Writer and I changed it to be a .pdf printer.