Create and customize charts to visualize data
Create a chart
To create a chart:
- Select the range for which you need a chart.
- Click Insert > Chart. A chart is generated to best represent the data.
- Click the chart to open the contextual side panel.
- Edit or modify the chart type, design, title, legend and color scheme of the chart from within the side panel
Note:
- The available chart types are:
- Bar Chart
- Column Chart
- Line Chart
- Pie Chart
- Scatter Chart
- Area Chart
- Web Chart
- Bubble Chart
- Stock Chart
- Time series
- Guage Charts
- Pareto Chart
- Waterfall Chart
- Wordcloud Chart
- Histogram
Change the title of a chart
To edit a chart's title:
- Click on the chart.
- Click on the Chart icon in the side panel.
- Go to the "Customize" tab on the side panel.
- Select "Chart Title" from the drop down menu.
- Key-in the title you want to be displayed on the space provided.
- Alternatively, you can double click on the chart to directly enter in the edit mode.
- Once in the edit mode, you can click on the title and edit the text as you need.
Change color scheme of a chart
To edit a chart:
- Click on the chart.
- Click on the Chart icon in the side panel.
- Move to the "Custom" tab on the side pane.
- Click on the "Styles" drop down menu.
- Choose from the colour schemes provided, or create a custom style that suits your need.
Change the transparency of a chart
To edit a chart:
- Click on the chart.
- Click on the Chart icon in the side panel.
- Move to the "Custom" tab on the side pane.
- Click on the "Styles" drop down menu.
- Now change the transparency using the slider.
Aggregate elements of a chart
To aggregate elements of a chart:
- Click on the chart.
- Click on the Chart icon in the side panel.
- While on the "General" tab on the side panel, click on the "Aggregation" drop down menu.
- You can choose one of the six functions listed, based on which the chart elements will be aggregated.
Publish a chart
To publish a chart:
- Right click on the chart you want to publish, and choose Publish from the drop down.
- Use the code snippet you get to embed or publish your chart.
- You can also choose to remove the public view of the chart by clicking Revert Publish from the menu.
Save a chart as an image
To save a chart as an image:
- Click Advance Options > Save As Image present in the menu.
- The chart is saved as a Portable Network Graphics (.png) image to your device.
Delete a chart
To delete a chart:
- Click Delete found in the menu when you select a chart.
- Alternatively, you can select the chart and hit the Delete key.