You can click to select a plot area, or right-click and use the mini toolbar to select. The plot area in an Excel chart sits in inside the chart area, and contains the actual chart. Hold down the alt key if you want to snap the chart to the gridlines. To re-size a chart, just use the drag handles. You can also right-click the chart area to change fill and line settings. When you hide gridlines on the worksheet this is a good way to blend a chart in with the background. Set the border to "No line" to remove the border entirely. You'll find controls for color, thickness, and many other line attributes, including rounded corners. To change the line around a chart, use the controls in the Border area. Once the chart area is selected, you can make a variety of formatting changes.įor example, I can change the fill another color, or even set the fill color to none, so that cells underneath show through. The Chart Elements menu on the Format tab of the ribbon, and the Format Task pane title will confirm the chart area is selected. The easiest way to select the chart area is to click just below the top edge of the chart. In this video, we'll look at how to work with the chart area and plot area in an Excel chart.Īll charts in Excel have a chart area, which encloses all elements of the chart.
0 Comments
Leave a Reply. |