Kanbanchi

How to create charts in Google Sheets

2 min read

Summary

Creating charts in Google Sheets allows you to visually represent data, making it easier to analyze trends and insights. Charts enhance clarity and help convey complex information quickly, improving decision-making and presentations.

The process is very easy. All you need to do is select all your data, click "Insert" and "Chart".

A chart will immediately show up in your spreadsheet.

More Google Workspace tips from Kanbanchi How to make a Google Sheets time tracker

In the chart editor, you can choose the type of chart that suits you best. There is a wide variety to choose from.

In the Customise tab, you can change other aspects of your chart, such as colours, minimum and maximum values, and much more.

Want to try the power of Kanbanchi and Google Workspace?

Watch how to create charts in Google Sheets

Necessary

These cookies are necessary for Our Sites to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of Our Sites will not then work. These cookies do not store any personally identifiable information.

Name	Provider	Purpose	Expiration
wordpress_, wp_	Kanbanchi	Internal cookie provided by CMS the website is built in.	Session
kanbanchi_website_cookie	Kanbanchi	Internal cookie for checking cookies health.	Persistent
pll_language	Kanbanchi	This cookie is used to remember the language selected by the user when he comes back to visit again the website by Polylang.	Persistent
_pk_*	Matomo	Analyse the use of the website and compile reports about the website activity.	Persistent
embed-privacy, moove_gdpr_popup	Kanbanchi	Track users’ cookie consent.	Persistent
__cf, cf_, _cf*, CF_Authorization	CloudFlare	CloudFlare service sets cookies to identify trusted web traffic. It does not correspond to any user id in the web application and does not store any personally identifiable information.	Session
access_token_production, amplitude_, amp_, amp_.organization.domain, CookieControl, deviceId, driftt_aid, eventId, identifyId, lastEventTime, optOut, org_login_production, sequenceNumber, sessionId, userId, _biz_, _fbp, _ga, _gid, _mkto_trk, _rdt_uuid, _uetvid, _zitok, __utmzz, __utmzzses	Amplitude	These cookies are used to analyze the user behavior within Kanbanchi website.	Persistent
_GRECAPTCHA	Google reCAPTCHA	We use Google Recaptcha to provide spam protection. We then compile reports which help Us improve Our Sites. This cookie sets as necessary cookie when executed for the purpose of providing its risk analysis.	Session
ar_debug, ga, _dc_gtm_UA-XXXXX-XX, _dc_gtm_, _gaexp, _gat, _gat, _gat_gtag_UA_, _ga_XXXXXXXXXX, _ga_, _gcl_au, _gid, __TAG_ASSISTANT, __utma, __utmc, __utmz	Google Analytics and Google Tag Manager	We use Google Analytics and Google Tag Manager to collect information about the usage of Our Sites. We then compile reports which help Us improve Our Sites. The core cookies of Google Analytics and Google Tag Manager collect information in an anonymous form, including the number of visitors to the site, where visitors have come to the site from, the pages they visited and the features they used.	Persistent
AADSSOTILES brcap Ccs CcsNtv CcsWeb ch, CkTst, CLID, cl, ea, ec, el, ESTSUSERLIST, ev, evt, fpc, gc, gv, ifm, lg, lt, mid, msclkid, MSPTC, MUID, p, pi, r, rn, rrc, sc, sh, sid, sw, threxp, ti, tl, ver, _cl, _uetmsclkid, _uetsid, _uetvid	Microsoft Universal Event Tracking	We use Microsoft Event Tracking to collect information about the usage of Our Sites. We then compile reports which help Us improve Our Sites. The core cookies of Microsoft Event Tracking collect information in an anonymous form, including the number of visitors to the site, where visitors have come to the site from, the pages they visited and the features they used.	sid is a Session cookie, other – Persistent

Functionality Cookies

Functionality Cookies enable Us to provide enhanced functionality and personalisation. They may be set by Us or by third party providers whose services We have added to Our Sites. If you do not allow these cookies then some or all of these services may not function properly. Also, Functionality cookies may help Us to count visits and traffic sources so We can measure and improve the performance of Our Sites.

Name	Provider	Purpose	Expiration
1_LIVE, APISID, HSID, LOGIN_INFO, PREF, SAPISID, SID, SSID, VISITOR_INF, YSC	YouTube	We use YouTube (a service of Google) to display video content on Our Sites. As part of this, YouTube sets various cookies to allow the correct Youtube video playback and store your preferences when viewing YouTube videos.	Persistent
1P_JAR, ACCOUNT_CHOOSER, ADS_VISITOR_ID, AEC, AID, APISID, DV, HSID, LSID, LSOLH, NID, OCAK, OGPC, OTZ, PSIDCC, SAPISID, SID, SMSV, SOCS, SSID, __Secure-	Google Accounts / Google Services	Google sets various cookies to authenticate users, prevent fraudulent use of login credentials, protect user data from unauthorized parties, as well as remember your preferences and other information, such as your preferred language.	Persistent
csrf.app, hubspotutk, IR_PI, messagesUtk, _cfuvid, _conv_v, _hjSessionUser_, _hs, _ttp, _tt_enable_cookie, __cf_bm, __hs*	Hubspot	These cookies are set by Hubspot. We use this tool for analyzing the use of kanbanchi.com and receiving requests from visitors. We then compile reports which help Us improve Our Sites.	_hssrc is a Session Сookie, others – Persistent
ajs_anonymous_id, .customer.io, _cio, _ga, _ga_	Customer.io	Some forms on our website collect data for the purpose of sending emails. Cookies will only be added in case of submitting these forms.	Persistent

Targeting Cookies

These cookies may be set through Our Sites by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Name	Provider	Purpose	Expiration
IDE, test_cookie	DoubleClick	Google’s Doubleclick uses cookies for targeting, optimisation, reporting and attribution of online advertisements.	Persistent
m-b, m-css_v, m-early_v, m-s, m-t*, m-uid	Quora	Uses cookies for targeting, optimisation and attribution of online advertisements.	Persistent
ct0, eu_cn, external_referer, guest_id*, lang, metrics_token, muc_ads, personalization_id, syndication_guest_id, tfw_exp, _twitter_sess	Twitter	We embed certain Twitter feeds on site. Cookies are set by Twitter to be identified on the web site through a Twitter account, as well as information on the content viewed by the user for Twitter’s display advertising.	lang and _twitter_sess are Session Cookies, others – Persistent
cb, datr, fr, usida, wd, _fbp	Facebook	We use Facebook information on the content viewed by the user for Facebook’s display advertising.	lang and _twitter_sess are Session Cookies, others – Persistent
_hj*	HotJar.com	Some pages of our website are monitored by our marketing team to provide a better experience and more relevant information.	Session
AnalyticsSyncHistory, ar_debug, bcookie, Bizo, bscookie, JSESSIONID, lang, li, li_, lms_, ln_, oribi, sdsc, UID, UserMatchHistory, _guid	Linkedin	These cookies are used as part of LinkedIn Insights and ad tags to track visitors from our LinkedIn marketing.	Persistent