Microsoft Office Tutorials and References
In Depth Information
Working with Charts
Alternatively, you can select a series in the chart, press Ctrl+1, and use the Format Data Series dialog
box shown in Figure 5-15. Note that this is a tabbed dialog box. Click the icons along the top of the
dialog box to view additional commands. It’s also a persistent dialog box, so you can click another
element in the chart. In other words, you don’t have to close the dialog box to see the changes you
specify.
Figure 5-15: Using the Format Data Series dialog box.
Working with Charts
As you develop your charts in Excel, you will find the need to move your charts around, resize your
charts, duplicate your charts, etc. The following section covers some of the common actions you will
inevitably have to perform when working with charts.
Before you can work with a chart, you must activate it. To activate an embedded chart,
click an element in the chart. Doing so activates the chart and also selects the element
that you click. To activate a chart on a chart sheet, just click its sheet tab.
Note
Moving and resizing a chart
If your chart is an embedded chart, you can freely move and resize it with your mouse. Click the
chart’s border and then drag the border to move the chart. Drag any of the handles to resize
the chart. The handles consist of dots that appear on the chart’s corners and edges when you
click the chart’s border. When the mouse pointer turns into a double arrow, click and drag to resize
the chart.
When a chart is selected, you can use the Chart Tools➜Format➜Size commands to adjust the height
and width of the chart. Use the spinners or type the dimensions directly into the Height and Width
commands. Oddly, Excel doesn’t provide similar commands to specify the top and left positions of
the chart.
Search JabSto ::




Custom Search