HongKiat: 5 Tools to Create Bar Chart Race Without Coding. “Data visualization is all these days – no matter what kind of information you want to present, either for school, work, or high-level corporate demos, it’s always important to present data in a very visual way…. Here are some solutions that you can use to create a bar chart race with or without pre-knowledge of coding.”
Washington Post: Dive into the data behind the news with How To Read This Chart, a newsletter from Philip Bump
Washington Post: Dive into the data behind the news with How To Read This Chart, a newsletter from Philip Bump. “In How To Read This Chart, we’ll consider good charts, parse complex ones and discuss how bad ones might be improved. We’ll look at ways in which information might be conveyed more effectively with lines than words. Analyses of pop culture, politics, economics — anything where there’s a number in the news. I’ve done this for a while, having worked as a designer at the software company Adobe and spending years translating data from the news into visuals, so I’m confident in serving as your tour guide.”
How-To Geek: How to Create and Customize a Waterfall Chart in Microsoft Excel. “If you want to create a visual that shows how positives and negatives affect totals, you can use a waterfall chart, also called a bridge or cascade chart. You can easily create and customize a waterfall chart in Microsoft Excel.”
How-To Geek: How to Use Excel’s “Quick Analysis” to Visualize Data. “Creating a chart in Excel is neither easy nor intuitive for inexperienced users. Luckily, there’s a feature called Quick Analysis that can create charts, tables, and more with just a click.”
Yale School of Management: Program on Financial Stability Launches Financial Crisis Chart Archive. “The Yale Program on Financial Stability (YPFS), in collaboration with the Hutchins Center on Fiscal and Monetary Policy at the Brookings Institution, has launched an online collection of charts and graphs illustrating key developments in the escalation of the global financial crisis of 2007–09, the government’s efforts to combat it, and the effects of those interventions.”
How-To Geek: How to Use Sparklines in Google Sheets. “When you’re working with large amounts of data in a Google Sheets spreadsheet, it isn’t always convenient to drop a chart into the mix. To help you, you can create one-cell charts using the SPARKLINE function instead. A sparkline chart is a very small line chart that allows you to quickly visualize your data. It’s useful if you want to quickly see if share price data in a spreadsheet was going up or down, for instance.”
How-To Geek: How to Build Instant Charts with Google Sheets’ Explore Feature. “The Explore feature in Google Sheets helps you gain insight from the data in your spreadsheets with the power of machine learning. Explore automatically analyzes everything in Sheets to make visualizing data easier.”
How-To Geek: How to Create a Gantt Chart in Google Sheets. “A Gantt chart is a commonly used type of bar chart that illustrates the breakdown of a project’s schedule into tasks or events displayed against time. Google Sheets has a handy feature to help you create a Gantt chart for your project.”
How-To Geek: How to Make a Graph in Google Sheets. “A data-heavy spreadsheet can be difficult to read through and process. If you’re using Google Sheets, adding graphs to your spreadsheet can help you present this information differently for easier reading. Here’s how you can add graphs to your spreadsheet. Before we begin, you should be aware of a slight difference in terminology. Like Microsoft Excel, Google Sheets refers to all types of graphs as charts. You can use the Chart Editor tool to create these graphs and charts in Google Sheets.”
Hongkiat: 20+ Useful Online Chart & Graph Generators. “Creating appealing and useful graphs require two things — good knowledge of statistics and a useful chart generator tool. While the former can be learned at school, for the later here are some of the best web services that allow you to create professional charts and graphs online. Let’s take a look at the list.”
How-To Geek: How to Automatically Generate Charts in Google Sheets. “Google Sheets gives you a wide variety of free graphs from which to choose. Whether you want to use a pie chart or something a little more complicated like a radar chart, you won’t be disappointed with the options available.”
Thanks to Esther S for the heads-up on this one: Add Colorful Charts to Your Google Spreadsheets. Quick read but useful; charts in Google Sheets drive me bonkers.
Google is making its spreadsheet charts more useful as embeds. “Charts help you display data in a visually compelling way. At work, the same chart may be used across multiple documents and presentations, to help you better convey your message and strengthen your argument. If that chart changes, it can be tedious and time-consuming to replace it in each and every file. To save you valuable time, we’re now making it possible to update your chart with a single click—without ever needing to leave your document or presentation.”
Quartz has opened up its chart/data platform, Quartz, to everybody. (And the chart-making tools, too!) “We are opening up Atlas to chart creators around the world, from researchers to analysts to fellow journalists and anyone else who regularly works with data. You can create an Atlas account starting now. We’ll be giving people access to make charts—slowly, at first, and then more rapidly as the platform evolves.” It’s invitation-only at the moment but access will expand over time.