Default Chart Location

frankule

New Member
Joined
Sep 15, 2014
Messages
10
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.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,625
Messages
5,523,970
Members
409,548
Latest member
Buildingbysea

This Week's Hot Topics

Top