A client showed me an issue I can easily duplicate – I initially thought it must be a bug in Excel but if it is its been there a long time as I tried rolling the version of C2R Office 365 back years to a version I had the command line for (A december 2021 release) and it made zero difference.

Basically they have a sheet of data. If they highlight the data and right click the Sheet link at the bottom and select Insert and chose chart it adds a new sheet with the new chart.

The problem is if they print the chart sheet the scaling is completely wrong and they’ll only get 30-70% of the chart. The scaling option etc are all unavailable when they create the chart this way.

Its not printer driver related as the same thing happens printing to the Microsoft Print to PDF driver too.

There are two ways to “fix” it – One is to add a new sheet and copy and paste the chart and then it behaves perfectly. Alternately if you go to the Page Layout tab on the toolbar and click the Page Setup button at the bottom that goes to the old page layout and tweak the paper size (even changing it to the wrong size and then back) it then seems to print ok.

I can repeat this behavior simply typing random numbers into a new sheet, highlighting the figures and doing the Sheet right click, insert chart and it won’t print correctly.

If they just make a chart on the current sheet it works too.

If I do the same on Excel 2010 it works perfectly so it seems to be an introduced “bug” that potentially isn’t encountered often due to the way people use Excel. I had never inserted a chart as a separate Sheet in this way before.

This seems to be broken behavior in Excel so even though I have a “work around” I figure its worth reporting as it seems it might be a legacy feature that is a little broken.

​A client showed me an issue I can easily duplicate – I initially thought it must be a bug in Excel but if it is its been there a long time as I tried rolling the version of C2R Office 365 back years to a version I had the command line for (A december 2021 release) and it made zero difference.Basically they have a sheet of data. If they highlight the data and right click the Sheet link at the bottom and select Insert and chose chart it adds a new sheet with the new chart.  The problem is if they print the chart sheet the scaling is completely wrong and they’ll only get 30-70% of the chart. The scaling option etc are all unavailable when they create the chart this way.Its not printer driver related as the same thing happens printing to the Microsoft Print to PDF driver too.There are two ways to “fix” it – One is to add a new sheet and copy and paste the chart and then it behaves perfectly. Alternately if you go to the Page Layout tab on the toolbar and click the Page Setup button at the bottom that goes to the old page layout and tweak the paper size (even changing it to the wrong size and then back) it then seems to print ok.I can repeat this behavior simply typing random numbers into a new sheet, highlighting the figures and doing the Sheet right click, insert chart and it won’t print correctly.If they just make a chart on the current sheet it works too.If I do the same on Excel 2010 it works perfectly so it seems to be an introduced “bug” that potentially isn’t encountered often due to the way people use Excel. I had never inserted a chart as a separate Sheet in this way before.This seems to be broken behavior in Excel so even though I have a “work around” I figure its worth reporting as it seems it might be a legacy feature that is a little broken.  Read More

​