Cannot copy scatter / stacked column combination chart

[Darren Bartrup]

I've created a combination scatter and stacked column chart in Excel 365.

The scatter chart is used to show red, amber or green circles and the labels - one series for each colour and another for the label. The label contents are sourced from a range of cells.
The column chart creates the boxes around each section.
In total there are 29 series linked to formula to make it all update properly.

The problem comes when I go to copy it into Powerpoint - either as a picture or chart. It won't copy and paste.
If I copy the whole sheet to another place in the workbook the chart isn't copied either.

If I remove most of the column chart series it does copy though.
Is there a limit to how many series can be copied in a chart or how complicate the chart can be?

Thanks for any advice in advance.

 

[Jon Peltier]

I don't know what the problem was that you encountered. I didn't expect any such problem.

So I replicated your exact chart with just 14 series. There was no problem copying the chart as a chart or as a picture. I don't imagine I'd have trouble even if my chart used 29 or 50 series.

 

[Darren Bartrup]

Thanks for the response Jon. Sounds like a problem with my sheet then.
I'll try rebuilding it on a new sheet, and if that doesn't work guess I'll have to rebuild the whole workbook.

I guess the arrangement of my data doesn't help with getting series count down. The RAG columns use Frequency to look up the percentage against a criteria and then the following four columns show either #N/A or X coordinate, with the four holding the labels.
I have a second table which contains the values for the background column chart - a table of 1's with 0.5 as the first so everything aligns.

I'll have to look through your site. Horizontal Bands for the background, not sure about the scatter part though. I guess one series for each colour, rather than three for each site.

Feel free to explain if you've got time.

 

[Jon Peltier]

As I said before, I doubt it's series count.

So what goes wrong? The chart just doesn't paste at all, or only part of it is pasted, or what?

 

[Darren Bartrup]

Yes, it doesn't paste at all. It's like I never copied it.

I've tried Ctrl+C, right-click and copy, trying copy and copy picture from the Home ribbon.
If I right-click the sheet tab and make a copy of the whole sheet, only the data on the sheet is copied and not the chart.

Completely take your word that it's not the series count.
Thinking it must just be some kind of corruption, but haven't had a chance to rebuild the chart yet to test - can hopefully do that on Friday.