An embedded chart can be moved anywhere on a worksheet. The easiest way to move a chart is to drag it around the worksheet.
To move a chart:
Click anywhere on the white space in the chart, and use the cursor to drag the chart anywhere on the worksheet.
Release the mouse button to place the graph in its new location.
Resizing a chart
Charts can be resized—made larger or smaller—to fit on a worksheet. Chart titles are sized in proportion to how large or small you make the chart. And within the chart area, the legend and/or plot area can be made larger or smaller. Chart titles can be moved but not resized.
Click anywhere on the white space of the chart area, plot area, or legend where you want to move or resize.
Point the mouse to one of the grab handles or resize cursor—the pointer changes to a double-headed arrow—to resize the chart.
Use the mouse to drag the sizing handle until the chart is resized to the desired size.
Deleting a chart
Any embedded chart or chart sheet can be deleted from a worksheet. A chart sheet is deleted in the same manner a worksheet is deleted. This section discusses how to delete an embedded chart.
To delete a chart:
Click anywhere on the white space of the chart area to select the chart.
Press the Delete key on your keyboard.
If you have difficulty deleting a chart, click anywhere outside of the chart and then select the chart again.
Challenge!
Open your Monthly Budget file.
Move the chart so it's located below row 19 and all of the data.
Resize the chart so it's larger than its current size.
Click anywhere on the white space of the chart area, plot
area, plot
An area chart or area graph displays graphically quantitative data. It is based on the line chart. The area between axis and line are commonly emphasized with colors, textures and hatchings. Commonly one compares two or more quantities with an area chart.
area, or legend where you want to move or resize. Point the mouse to one of the grab handles or resize cursor—the pointer changes to a double-headed arrow—to resize the chart.
You can move a chart to any location on a worksheet or to a new or existing worksheet. You can also change the size of the chart for a better fit. By default, a chart is moved and sized with cells. When you change the size of cells on the worksheet, the size of the chart adjusts accordingly.
Click the chart, and then drag the sizing handles to the size that you want. Click the chart, and then on the Format tab, in the Size group, enter the size in the Shape Height and Shape Width boxes.
Click "Don't Move Or Size With Cells" to fully lock the chart against being resized by Slicer selections or moved by users adding or removing columns. Alternatively, there is also an option to "Move But Don't Size With Cells" if that fits your needs better.
Usually, we move or change the size of the chart within excel to ensure that the chart will not cover its underlying data. We can move the chart to a new location in the worksheet or to a new or existing worksheet. Also, we resize or change the size of the chart for a better fit in the worksheet.
Go to File > Options > Advanced, and scroll halfway down to the Chart section.Then Uncheck the box for Properties Follow Chart Data Point for Current Workbook. I wrote an article about this setting: Properties Follow Chart Data Point.
File > options > advanced > chart > uncheck auto-update option. File > Options > Advanced > uncheck Extend data range formats and formulas. File > options > advanced > chart > deselect both “Properties follow chart data point for current workbook” and “properties follow chart data point for all new workbooks”
Hobby: Reading, Ice skating, Foraging, BASE jumping, Hiking, Skateboarding, Kayaking
Introduction: My name is Cheryll Lueilwitz, I am a sparkling, clean, super, lucky, joyous, outstanding, lucky person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.
If you have difficulty deleting a chart, click anywhere outside of the chart and then select the chart again.
