Setting up the data table

Before creating a chart, you must enter data on your spreadsheet that can be represented graphically. For this tutorial, you will first create a table representing typical monthly expenses in the categories House, Car, Utilities, Groceries, and Other.

To set up the data table

1. In cells A1 to A5, type the labels House, Car, Utilities, Groceries, and Other.
2. In cells B1 to B5, type the values 1000, 400, 250, 250, and 500.
3. Select cells B1 to B5.
4. Click Format menu Selection properties.
5. Click the Numeric format tab.
6. Click Currency.
7. Click OK.

Continue