Chart is blocking my cells

[bassicexcel]

Capture.JPG

Hello could someone please assist me.
I used an online tutorial to create a speedometer using two donut charts and a pie chart.
At the end of the tutorial it had me group everything together.

When I drag and place the image it is blocking some of my cells and I cannot edit them (see red box)

I've tried to "send the image" to the background but this does not work too.

Anyone have an idea?

Thank you!

[dosydos]

The only options i can think of that will only act as a bandaid:
1) Make charts smaller before grouping so that it doesn't overflow into your data cells.
2) the grouping is only as big as the combined charts together so maybe shrink or adjust the chart somehow that is at the bottom?
2) You could insert a couple of blank rows and deal with the extra space there.
3) A really terrible idea that will take a ton of time and will make your life complicated and probably not even look good... Add textboxes to all those cells and make sure there properties have "move and size with cells" selected. Then make sure all the text boxes are "Brought to front" <-- seriously don't do this idea

[Andy Pope]

You could use a linked picture which only covers the top half of your grouped shape.

Or rebuild the chart using xy-scatter rather than donut/pie as then you can create a semi circle.

If you want more help attached example file rather than a picture

[bassicexcel]

Thank you both for your suggestions.
I will try out and see what I can come up with.
Have a nice day and Happy Holidays