positioning charts

[mshbhwn98]

Hi,

I have some charts on a spreadsheet but they are positioned over cells that are hidden by a macro when you push a button. What is the best method for keeping them visually in the same position when hiding and ungiding columns/rows?

Thanks

[p45cal]

right-click the chart, choose Format chart area…, choose Properties, under Object positioning choose Don't move or size with cells, click Close.