How to remove border from chart area and increase padding?

Hi,

I am using a chart to export a range of shapes as a picture.

However, I get an unwanted line around the chart and I want to remove the border.

I would also like to increase the padding around the shape that I am pasting into a chart.

Please Login or Register  to view this content.

I have tried recording a macro but it gives the chart a new name every time.

Any suggestions?

I found a working solution in another thread.

Please Login or Register  to view this content.

Still interested in how to add padding around the chart?