The last formula gives the total money you paid for the week. Click the I7 cell, click the
Function button, and choose Sum. This adds all the totals for each individual day in row 7 and
displays the results in cell I7.
Create a Chart Using the Table??™s Data
Charts always liven up a spreadsheet, and our example spreadsheet certainly needs a little life
pumped into it. To create a quick chart from your table, select the Weekly Expenses table in the
Sheets pane, and then click the Charts button and click the first chart in the upper-left corner.
168 How to Do Everything: Mac
This action automatically creates a chart that shows all the data you entered for the week, and
even color-codes it for you.
This is simply as easy as anyone can expect it to get. But let??™s not just leave it at easy, let??™s go
for cool! Delete that chart and create another one using the Charts list. I selected this chart??¦
CHAPTER 7: I Work, You Work, We All Work with iWork 169
??¦and got this really neat result:
Continue to play with the chart options to see what neat creations you can come up with.
Pages:
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237