![how to make a pie chart in excel mobile how to make a pie chart in excel mobile](http://img.chandoo.org/c/pie-chart-rule-settings-v1.png)
![how to make a pie chart in excel mobile how to make a pie chart in excel mobile](http://img.bhs4.com/26/2/2628A431CA5B24CA6002A89D04422127CB6C0D35_large.jpg)
It allows you to change the location of a chart, but it also reports the current location. This works in both directions.įinally, note that the Move dialog does two things. Just select the chart, right-click, and choose Move Chart from the menu. When you finish, click Apply Filter or check the box for Auto Apply to see. Use the Filter section of the pop-up box to filter by color, condition, or value. Click the arrow at the top of the column for the chart data you want to filter. You can also right-click to move a chart. Go to the Home tab, click the Sort & Filter drop-down arrow in the ribbon, and choose Filter. When you click OK, Excel will remove the standalone chart from the workbook, and place the chart back into Sheet1. This time, select Object in, and choose Sheet1. To move the chart back to Sheet1, click Move Chart again. You're free to change the page orientation if you like. If you visit the Print pane under the File menu, you'll see that the chart has been configured to occupy the entire page. Standalone charts are more spacious than embedded charts.
![how to make a pie chart in excel mobile how to make a pie chart in excel mobile](https://saylordotorg.github.io/text_how-to-use-microsoft-excel-v1.1/section_08/38756b65606625589ec2bec5ea58daf8.jpg)
When you click OK, Excel will remove the chart from the existing worksheet and place it into a new worksheet. The new sheet will be to the left of the sheet you started on. You could also give the chart a different name at this point. The Move Chart dialog will open and you'll see two options: "New Sheet" and "Object in." Select New Sheet. Then, go to the Design tab under Chart Tools and click the Move Chart button. To move a chart into its own sheet, first, select the chart. But if you're short on space, or, if you'd just rather have a chart in its own worksheet, you can easily do so. Normally, when you choose a chart type on the ribbon, Excel creates an embedded chart which floats over the worksheet grid below.
#How to make a pie chart in excel mobile how to#
In this lesson we'll look at how to move charts from one state to the other. Excel charts can exist in two states: as an embedded object in a worksheet, floating above the worksheet grid, or, in a worksheet all by themselves.