When you create a chart in Excel, the chart can be either embedded as an object within an worksheet, or you can add the chart as its own worksheet. Each type of chart has its advantages, and at some time you might want to change a particular chart from one type to the other. In order to do this, follow these steps:
Figure 1. The Move Chart dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6193) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Changing Chart Type.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Excel's charts are normally created in color, but you can print them in black and white. You may be looking for a way to ...
Discover MoreWhen creating a line cart, the line can show values both positive and negative values. This tip explains how you can use ...
Discover MoreCreate a chart in Excel, and you may find that the tick marks shown on the axes in the chart aren't to your liking. It is ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2013-12-09 11:43:44
BillD
And probably stating the obvious, just moving an embedded chart between tab sheets works with cut-and-paste. Within a sheet, it's easiest to drag the chart. If it's a "lengthy" drag, cut-and-paste can expedite the task. But be advised, after a cut/paste-chart operation, excel increments the assigned chart number, e.g., "Chart 2" becomes "Chart 3" --a pitfall for simple macro code.
2013-12-09 10:55:16
Bryan
This tip uses the wrong terminology. The place where the chart is located is called the chart location. Chart type refers to the style in which the data is plotted. This should be titled "Changing Chart Location".
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments