Create Charts with Spreadsheet Data

Turn any range of your spreadsheet data into a chart. Charts dynamically update to reflect changes to your spreadsheet data.

Required Editions

Available in: Quip desktop app, Quip iOS mobile app, and Quip on web
  1. Highlight the spreadsheet data that you want to visualize.
  2. From the Insert menu, select Chart.
  3. Select the type of chart that you want to make. Quip creates the chart from your data.
  4. To change how the chart looks, double-click the chart, or from the chart menu, select Edit Chart.
  • Customization Options for Charts
    After you create a chart, use the Chart Editor to customize the data the chart uses, select a new chart type, update the chart labels, and more.
  • Area Charts
    Use an area chart to spot trends in data over time. Use a stacked area chart to visualize parts of a whole in datasets over time.
  • Bar Charts
    Quip provides these types of bar charts: bar, stacked bar, and bar stacked to 100 percent. Use a bar chart to compare related values. Use a stacked bar chart to compare parts of a whole and show values across one or more categories. Use a bar chart stacked to 100 percent to compare the proportions between values in one or more categories.
  • Bubble Charts
    Bubble charts use the size and coloring of bubbles to show multiple dimensions and measures. Use a bubble chart to illustrate the relationship between two columns of numerical data in your spreadsheet. A third numerical column represents the size of each bubble in the chart.
  • Column Charts
    Quip provides these types of column charts: column, stacked column, and column stacked to 100 percent. Use a column chart to compare related values. Use a stacked column chart to compare parts of a whole and show values across one or more categories. Use a column chart stacked to 100 percent to compare the proportions between values in one or more categories.
  • Combo Charts
    Combine a bar chart and a line chart to show more than one data series.
  • Donut Charts
    Use a donut chart when you have a grouping and want to show not only the proportion of a single value for each group member against the total, but also the total amount itself.
  • Line Charts
    Use a line chart when you have one important grouping representing an ordered set of data and one or more values to show.
  • Pie Charts
    Use a pie chart when you have multiple groupings and want to show the proportion of a single value for each grouping against the total.
  • Scatter Charts
    Use a scatter chart to show correlation between two groups of data.