Create charts to visualize your data

Create charts to visualize your data

How to create a chart

To create a chart:
  1. Select the range of cells you want to visualize.
  2. Go to Insert and select a chart type of your choice.
  3. Select the chart and click the Chart icon  from the side pane to edit the chart type, design, title, legend, color scheme, and more.

The following chart types are available:

  1. Bar Chart
  2. Column Chart
  3. Line Chart
  4. Pie Chart
  5. Scatter Chart
  6. Area Chart
  7. Web Chart
  8. Bubble Chart
  9. Stock Chart
  10. Time series
  11. Guage Charts
  12. Pareto Chart
  13. Waterfall Chart
  14. Wordcloud Chart
  15. Histogram

How to change the title of a chart

To change the title of a chart:
  1. Select the chart and click the Chart icon in the side pane.
  2. Go to the Format tab in the side pane and enter a title.
  3. Alternatively, you can double-click the chart to open the edit window. Then, click on the chart title to modify it.
 

How to change color scheme of a chart

To change color scheme:
  1. Select the chart and click the Chart icon in the side pane.
  2. Go to Design > Styles.
  3. Choose color schemes from the options or create a custom style that fits your need.

How to change the transparency of a chart  

To change the transparency of a chart:
  1. Select the chart and click the Chart icon in the side pane.
  2. Go to Design > Styles.
  3. Adjust the transparency using the slider.
 

How to Aggregate elements of a chart  

To aggregate elements of a chart:
  1. Select the chart and click the Chart icon in the side pane.
  2. Go to Data > Aggregate.
  3. You can choose any of the listed functions, based on which the chart elements will be aggregated.

How to publish a chart

To publish a chart:

  1. Right-click on the chart you wish to publish.
  2. Select Publish from the contextual menu.
  3. Use the code snippet to embed or publish your chart.
  4. To unpublish a chart, right-click on the chart and click Unpublish from the contextual menu.

How to save a chart as an image

To save a chart as an image:
  1. Right-click on the chart and select Save as Image from the contextual menu.
  2. The chart is saved as a Portable Network Graphics (.png) image to your device.
 

How to delete a chart

To delete a chart:
  1. Right-click on the chart and select Delete from the contextual menu.
  2. Alternatively, select the chart and hit the Delete key.