---
schema_version: "1"
id: 218ad494975d1fcddef2d6b77b94f3f9b2d5d5633d6429b2c3bf1be2f4ff79b2
title: Create Charts with Spreadsheet Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_charts_spreadsheet.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_spreadsheet.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a9ecffe7be1e5dd98a5927baa531c0295fd868e84bebb989d52b6ea8ee351c12
description: Turn any range of your spreadsheet data into a chart. Charts dynamically update to reflect changes to your spreadsheet data.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# 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

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Quip desktop app</strong>, <strong>Quip iOS mobile app</strong>, and <strong>Quip on web</strong></td></tr></tbody></table>

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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_edit_options.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_area.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_bar.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_bubble.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_column.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_combo.htm&release=264.0.0&type=5)**  
    Combine a bar chart and a line chart to show more than one data series.
- **[Donut Charts](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_donut.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_line.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_pie.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=xcloud.quip_charts_scatter.htm&release=264.0.0&type=5)**  
    Use a scatter chart to show correlation between two groups of data.