Default Chart Location

[frankule]

Im using Excel 2007. When I make a chart it just automatically puts it on my worksheet but I want it to be on its own sheet. Its a bit annoying to create it, then pick move chart and choose a new sheet. Is there any way to set a default to make as a new sheet or at least give me the option to choose without having to go and pick move?

Thanks.

 

[Damon Ostrander]

Hi frankule,

I don't recall any setting for this in Excel 2007. I think perhaps the best way to make it easier would be to add a custom button to one of your toolbars that calls a macro which changes the location of the selected chart to its own chart sheet.

Damon

 

[frankule]

I never would have thought of that... Works like a charm! Thanks.