Google Charts is highly versatile, and user acceptance can be high
September 14, 2019

Google Charts is highly versatile, and user acceptance can be high

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Google Charts

Google Charts is being used across our entire organization as we became a Google For Work company. It has replaced Microsoft Office products, primarily Microsoft Excel.
It allows for improved sharing of documents across departments. Multiple users can access files, and we can track changes and usage to see what people are doing and how effective our tools have become.
  • Sharing tools between multiple users.
  • Good customization, though there is still more that can be done.
  • The availability of new formulas in Google Sheets that allow for SQL style programming.
  • Processing speed with relatively large datasets. 10000 rows across 15 columns takes some processing time to manipulate, even 1500 rows can take 1-2 minutes just to process.
  • More customization, particularly for visual improvements like color gradients. We're happy that finally the borders of charts can be removed.
  • Fix the #REF! errors for the IMPORTRANGE formula. If you want businesses to use your products, it can't break every day multiple times because your formula for some reason doesn't want to work. A refresh can fix it some of the time, but it shouldn't break period.
Really we have only used Microsoft Excel, and we do have a BI Tool in Qlik Sense.
Against Excel, Google Sheets allows for better sharing, tracking, and added formulas through SQL style syntax and the Filter formulas. It is lacking in visual customization, where Excel is far superior. Processing speed can depend on what you are doing. In some cases, Google Sheets is better, but when filtering lists and including lots of index type formulas, Excel seems to outperform Google.
Against Qlik Sense, Google can't handle large data sets, but it beats Qlik Sense in customization and usability.
If you need to share information across multiple staff, it is a great tool. Being able to visually see other people working was a little weird at first, but it is very helpful to track progress. There are new ways to manipulate data in Google Sheets, with new formulas that let you create manual variable inputs to have graphs and charts update with your selections.

Google Charts Feature Ratings

Pixel Perfect reports
2
Customizable dashboards
8
Report Formatting Templates
7
Drill-down analysis
7
Formatting capabilities
8
Integration with R or other statistical packages
8
Report sharing and collaboration
10
Publish to Web
9
Publish to PDF
8
Report Versioning
7
Report Delivery Scheduling
8
Delivery to Remote Servers
8
Pre-built visualization formats (heatmaps, scatter plots etc.)
2
Location Analytics / Geographic Visualization
1
Predictive Analytics
3
Multi-User Support (named login)
10
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
8
Single Sign-On (SSO)
10
Responsive Design for Web Access
8
Mobile Application
Not Rated
Dashboard / Report / Visualization Interactivity on Mobile
9
REST API
Not Rated
Javascript API
Not Rated
iFrames
Not Rated
Java API
Not Rated
Themeable User Interface (UI)
Not Rated
Customizable Platform (Open Source)
Not Rated