Pages

Monday, November 29, 2010

Tip of the Week: Excel Charts

Charts display numbers in a picture form. Creating a chart in Excel starts by entering the data on a worksheet. The data can be arranged in rows or columns. Excel can automatically determine the best way to plot the data in the chart. A chart can also be built manually.

To create a chart automatically:
After entering the data on a worksheet, highlight the data to be charted. Press F11. A chart appears.
To create a chart manually:
After data is entered, click on the Insert ribbon and look for the Chart tab. Choose the chart type and sub-type to plot the data.

To modify a chart:
Clicking anywhere in a chart makes the Chart Tools available, adding the Design, Layout, and Format tabs. Within each of these tabs contains options to modify and format the plot area, data points, horizontal and vertical axis, legend, chart and axis title, as well as data labels.

0 comments: