Tip of the Week: Chart Improvements

Application: Excel 2010

Excel 2010 has enhanced charting features. In older versions of Excel, charts limited the number of data points. Formatting chart elements is easier in 2010-double-click any part of the chart for a dialog box to open. Colors, patterns, fills, and more can be modified.

Inserting a Chart

1. Enter the data to be charted on a worksheet.
2. Select the cells containing data to be charted.
3. On the Insert tab, in the Charts group, choose a chart type by clicking the down arrow by a chart name.
4. The chart will appear on the worksheet. The Chart Tools toolbar will become available if modifications are needed.

For more information about chart formatting options in Excel 2010, see this Microsoft article entitled Change the format of chart elements.