11 Dec View a miniature chart within a single cell in Google Sheets using Sparkline
View a miniature chart within a single cell in Google Sheets using Sparkline: Just launched this week, Google have now announced a handy new feature for Google Sheets called Sparkline, which allows you to visualise the data in a row or column with a miniature chart in a cell. The chart can be a line, bar or column and easily lets you analyse if targets or forecasts are being met.
To get started with Sparkline, you will need to create a new Google Sheets document, and input your numerical data.
Next, you need to enter the formula in the next cell along which will produce your chart. The formula you need to enter is =sparkline(data range), as shown below.
Hit enter, and a line chart will appear depicting your data. The line chart is the default setting, and you can edit this easily to a column or bar chart.
To change your chart type, click on the cell and head to the formula bar to make changes. Here, you want to add additional information inside the brackets. Add {“charttype”,”column”} to create a column chart, or {“charttype”,”bar”} for a bar chart.
Add the closed bracket after this and hit Enter on your keyboard to view your new chart.
To add additional edits to your chart, such as colour or axis, you can find more features here. This feature is on a rapid and scheduled release track, and will be available for all Google Apps users shortly.
For more tips and tricks for using Google Apps for Work, visit our Google Apps Tips blog.
No Comments