Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel ROWS Function
  • Basic INDEX MATCH approximate in Excel
  • How to get last column number in range in Excel
  • How to use Excel FORMULATEXT function
  • How to use Excel OFFSET function

Data Analysis Examples

  • Data Series in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Add Outline to Data in Excel
  • Filter Data Based on Date in Excel

Data Validation Examples

  • Excel Data validation must begin with
  • Excel Data validation with conditional list
  • Excel Data validation no punctuation
  • Excel Data validation require unique number
  • Excel Data validation date in specific year

Move chart to a separate worksheet in Excel

by

So far we have only seen charts on the same worksheet as the source data (embedded charts). However, you can also move a chart to a separate sheet that only contains a chart (chart sheet).

To move a chart to a chart sheet, execute the following steps.

1. Select the chart.

2. On the Design tab, in the Location group, click Move Chart.


The Move Chart dialog box appears.

3. Click New sheet and enter a name.

4. Click OK.

Result:

Note: repeat these steps, but instead of New sheet at step 3, click Object in, to move the chart back to the same worksheet as the source data.

Post navigation

Previous Post:

How to Create Thermometer Chart in Excel

Next Post:

Create Scatter Chart in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to display conditional message with REPT function in Excel
  • UNICODE function: Description, Usage, Syntax, Examples and Explanation
  • Add line break based on OS in Excel
  • How to strip non-numeric characters in Excel
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Calculate time difference in hours as decimal value in Excel
  • How to determine year is a leap year in Excel
  • Get day name from date in Excel
  • Count dates in current month in Excel
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • Calculate loan interest in given year in Excel
  • FVSCHEDULE function: Description, Usage, Syntax, Examples and Explanation
  • NPV function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYBS function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles