Create the Formulas
The next
steps use a formula to create a Relative Cell Reference that
links data from the Sales Subtotal by Month spreadsheet that Subtotals each
Month's
sales.
3. Try it: Create the Formulas
Start on
the Sparkline spreadsheet.
All
equations begin with equals.
Select
Cell B2 and type: =.
Go to the
Sales Subtotal by Month sheet and click on the
amount for January in Column H.
Select Cell B3 and type: =.
Go to
Sales Subtotal by Month and click on the amount for
February in Column H.
Please
create formulas for the other months as well. Keep going...!
Memo to Self: You can use the
sample spreadsheet
or just type the data that
you see on this page if you
wish.