Forum Discussion
Creating a New Chart - Automatically Placing Chart in a New Sheet
Thanks in advance. Simple steps: When I am creating a chart in Excel, I am selecting recommended charts, and then selecting "Ok". The program automatically creates the chart in a new sheet wi...
If from recommended charts is selected PivotChart type, such chart is always placed into new worksheet together with related PivotTable. To my knowledge there is no way to change such behavior, Excel can't find right place for the PivotTable in current sheet.
If regular chart is selected, it shall be placed in the middle of the current grid working area.
I guess we don't speak about F11 and Alt+F1.