Our previous Excel Tutorial Lesson 21, we learn about how to create an embedded chart that appears on the same sheet with the source data in excel. Today's lesson, we shall learn how to create a chart sheet that appears on a separate worksheet from the source data.
A chart sheet is created on a separate sheet in the same workbook with your source data. Chart sheets do make your charts stand out, especially when working with complicated spreadsheets. To create a chart sheet, you can simply move your embedded chart to the next sheet in your current workbook.
=> First of all, create an embedded chart,
=> Then select the chart to be moved to a new worksheet,
Choose Chart => Location from the menu bar.
In the Chart Location dialog box, select the As a new sheet radio button. (When you choose the As object in radio button, it will add the chart as an embedded object on the worksheet.)
Then click the OK button.
The chart will now display on the next worksheet in the same Workbook.
You can also use the Chart Location dialog box to rename the Chart Sheet.
=> Create your embedded chart first,
=> Click on the chart first, the the Design tab will show.
=> Click on the Design tab,
=> At the far right corner of your excel sheet, click on Move chart to move the chart to another sheet or tab in the worksheet.
=> The next pop-up dialog box will ask you to choose where you want your chart to be placed.
=> Select New sheet and enter a new name for your chart sheet.
=> Then hit Ok. That's all. Your chart will now appear on a separate worksheet.
CONGRATULATIONS! You have now come to the end of our Excel Online Tutorial Lessons.
I hope you enjoyed our tutorial lessons from the beginning? please feel free to share this post with your friends using the like/share buttons. You can also subscribe to this blog below for more tips delivered to your inbox. Thank you.
A chart sheet is created on a separate sheet in the same workbook with your source data. Chart sheets do make your charts stand out, especially when working with complicated spreadsheets. To create a chart sheet, you can simply move your embedded chart to the next sheet in your current workbook.
How To Move an Embedded Chart to a Chart Sheet
=> First of all, create an embedded chart,
=> Then select the chart to be moved to a new worksheet,
Choose Chart => Location from the menu bar.
In the Chart Location dialog box, select the As a new sheet radio button. (When you choose the As object in radio button, it will add the chart as an embedded object on the worksheet.)
Then click the OK button.
The chart will now display on the next worksheet in the same Workbook.
You can also use the Chart Location dialog box to rename the Chart Sheet.
To Create a Chart Sheet on Excel 2010
=> Create your embedded chart first,
=> Click on the chart first, the the Design tab will show.
=> Click on the Design tab,
=> At the far right corner of your excel sheet, click on Move chart to move the chart to another sheet or tab in the worksheet.
=> The next pop-up dialog box will ask you to choose where you want your chart to be placed.
=> Select New sheet and enter a new name for your chart sheet.
=> Then hit Ok. That's all. Your chart will now appear on a separate worksheet.
CONGRATULATIONS! You have now come to the end of our Excel Online Tutorial Lessons.
I hope you enjoyed our tutorial lessons from the beginning? please feel free to share this post with your friends using the like/share buttons. You can also subscribe to this blog below for more tips delivered to your inbox. Thank you.
Read more: http://www.cyracksinternetbiz.com/2014/01/excel-tutorial-lesson-22-creating-chart.html#ixzz3kFn6Kdch
Follow us: @cyracksjay on Twitter | cyracksinternetbiz on Facebook
No comments:
Post a Comment