Created attachment 174885 [details] Calc spreadsheet (source) If I copy the chart in the attached ODS (Sheet 2) to an Impress slide, the chart comes across but with one change: In Calc, the Y axis is labeled in percentages (0-100%). This is correct. In Impress, the Y axis is label in decimals (0-1.0). This is wrong.
The y-axis in the chart has enabled "use Source Format" in the 'Number' tab of the properties dialog. When you copy the chart to Impress, the relationship to the spreadsheet is cut, so the axis does not find the format. So before you copy&paste the chart to Impress, uncheck this option. You can check it again, after you have copied the chart.
Thanks for the explanation but I fail to see how that's not a bug from the user's perspective? I don't have to fiddle with any other settings when shifting charts between applications to get something that's otherwise identical, and from a user perspective there's nothing at all that's special about this particular setting. It's certainly non-obvious behaviour to a user, and when I saw it my first thought was "I don't feel like spending the next 10 minutes fiddling around trying to find the one setting that might fix this". Instead I simply took a screenshot of it from calc and used that, completly bypassing this entire feature.