Forum Discussion
Custom labels aren't applying properly when copy/pasting filtered charts between applications
Edit: I believe this is a bug in Excel [Version 2208 (Build 15601.20538 Click-to-Run)]. See my second reply below. When attempting to embed paste a copied chart from Excel 2016 to another applica...
If you paste the chart into another application unfiltered, and then filter it after being embedded, it works fine. However, even copying that 'fixed' chart won't correct the issue - it still pastes with incorrect custom labels.
My use case is that I paste embedded, update the sizing as needed, then copy that embedded chart, delete, paste as picture. This pastes it without a border (unlike if you just paste as picture initially) and ensures proper sizing. This does not work with the above defect.
My use case is that I paste embedded, update the sizing as needed, then copy that embedded chart, delete, paste as picture. This pastes it without a border (unlike if you just paste as picture initially) and ensures proper sizing. This does not work with the above defect.
- More research into this - it appears that, as of a recent update, when you paste a filtered chart as embedded, the chart's range is truncated (probably in an attempt to reduce memory footprint). That is, if you have a chart that covers B2:C6, and you paste the middle three rows, Excel's embed only contains B3:C5 if you look at Select Data in the embedded instance. However, this truncated range does not carry over to the Custom Labels select box, which still is only reflecting the original range. This may be due to how Excel handles custom labels (since they can be an entirely separate set of cells with no correlation to the original dataset size), but it's 100% an Excel bug. I can't find documentation around this.