How to Make Charts to Visualize Your Data

After you run a query, look for the Chart button to create a chart.

Line chart

Let's look at how many questions are asked per day on StackOverflow:

select *
from `bigquery-public-data.stackoverflow.posts_questions`
where creation_date between '2020-01-01' and '2020-01-31'

line chart

If we wanted to see two series, one for answered questions, and another for unanswered questions, we need an answered boolean column:

select
  *,
  answer_count > 0 as answered
from `bigquery-public-data.stackoverflow.posts_questions`
where creation_date between '2020-01-01' and '2020-01-31'

line chart two series

Here's a video tutorial showing how to create a line chart:

Bar chart

Let's look at the top 10 most popular tags on StackOverflow and make a bar chart.

select *
from `bigquery-public-data.stackoverflow.tags`
order by count desc
limit 10

bar chart

Pie chart

Using the results from the previous pie chart example, here's what it would look like if we changed the chart type to a pie chart:

Ready for a modern SQL editor?