• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Tips for using Google Sheets

Get PDF file

by on
in Office software,Office Technology

Sparklines in Sheets?

Q. Can you do Sparklines in Sheets?

A. Yes. It is done with a formula. Let’s say you had some sales data recorded over a period of three weeks, and you wanted to show a trend line in the cells to the right of the data. Click in the first cell to the right of the first series, and type:

=SPARKLINE(B2:D2)

This will produce a sparkline using the data in B2 through D2. There are several types of sparklines you can add by specifying a chart type and other parameters. For example:

=SPARKLINE(B2:D2,{“color”,”red”})

will change the color of the sparkline to red. This:

=SPARKLINE(B3:D3,{“chart type”,”bar”})

will produce a bar chart. Click into the formula to reveal the pop up help, and then click on Learn more about SPARKLINE to see all of the options available to you.

Notes and comments in Sheets

Q. What’s the difference between a Note and a Comment in Google Sheets?

A. Basically, a note is extra information assigned to a cell in a worksheet. Unless someone types in his name, it is not associated with a particular user. When the note is hidden, a black triangle displays at the top right of the cell to which it is attached. When a comment is entered, it shows as a colored triangle in the upper right corner of the cell. When you hover over that cell, it will show you who made the comment and gives you a Resolve button used to edit or delete it.

VLookUp is different

Q. There is no Range_LookUp para­­meter in Sheets. There is something though in that fourth position in the syntax called “[is_sorted}.” What does it do?

A. The “is sorted,” or its negative value FALSE, meaning, not sorted, will tell Sheets whether it is allowed to find a close match to your look up value or search_key as they call it in Sheets. If it is not sorted, it will only return the exact value (Think FALSE in an Excel VLookUp. It does the same thing, essentially.) If it is sorted, then Sheets will return the closest value it can find if it can’t find it exactly, which is the default behavior of TRUE in an Excel VLookUp. In Excel, it may just appear as a blank fourth parameter. So, it pretty much does the same thing.

Leave a Comment