77. Excel Tips - Put Chart On A New Sheet

Nick's picture


Today's tip is a simple one on how to move a chart

  • By default, Excel adds a chart to the current worksheet
  • You can easily move a chart off a sheet and onto it's own chart worksheet

Here's a screen shot of how our chart looks in Excel:

put-chart-on-a-new-sheet

Here's how we want it to look:

put-chart-on-a-new-sheet

Steps:

  1. Right click on the chart
  2. Choose: Move Chart
  3. Choose: New Sheet

Download sheet to practise how to Put Chart On A New Sheet in Excel

Training Video on how to Put Chart On A New Sheet in Excel:

AttachmentSize
put-chart-on-a-new-sheet.xls34 KB