Welcome toExcel2007.Tips.Net
Helpful Links
Excel2007 Tips
Home Tips
Organizing Tips
Wedding Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Changing a Chart's Type
Summary: Charts can either be embedded in a worksheet or take up an entire sheet by themselves. Changing from one type of chart to the other is easy to do by using a control on the Design tab of the Ribbon.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:
- Select the chart you want to change. If working with a chart object, then you should see a series of handles around the perimeter of the chart. If working with a chart sheet, the chart sheet should be displayed.
- Make sure the Design tab of the Ribbon is displayed. (This tab is only visible if you've selected the chart, in step 1.)
- Click the Move Chart option, in the Location group, at the right side of the Ribbon. Excel displays the Move Chart dialog box. (Click here to see a related figure.)
- Choose whether you want the chart displayed as a sheet or as an object.
- If you choose that you want the chart displayed as an object, use the drop-down list to select the worksheet on which the chart object should appear.
- Click on OK.
Related Tips:
More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!