AppsCare | View a miniature chart within a single cell in Google Sheets using Sparkline - AppsCare
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
17425
single,single-post,postid-17425,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

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.

Google Apps Tips - Google Sheets Sparkline

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.

Google Apps Tips - Google Sheets Sparkline

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.

Google Apps Tips - Google Sheets Sparkline

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.

Google Apps Tips - Google Sheets Sparkline

Add the closed bracket after this and hit Enter on your keyboard to view your new chart.

Google Apps Tips - Google Sheets Sparkline

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.

Claire Stead
cstead@appscare.com
No Comments

Post A Comment