How To Customize Charts

In this tutorial we’ll show you how to customize the most popular chart types: column, pie and line. You might also want to look into this article that covers the customization of maps.

The Column Chart

ccTo get started, just pick any chart. We’ll use a regular column chart for this example.

cc1Double-click to edit.

cc2You can enable or disable the grid to remove or add guidelines to your chart. The grid can make your data easier to follow, but can also be distracting. Use the grid if the value of each specific data point is important. Turn it off if you’re trying to show an overall trend.

cc3Enable Absolute values to lock the range of the Y-axis. This is useful when you use radio buttons to compare different data sets.

cc4You can choose to show the values of your data directly on the columns. However, your readers will be able to see the numbers even if you don’t display them thanks to the interactivity or our charts. Think whether you absolutely need to show them, otherwise remove them to make the chart cleaner.

cc5Use radio buttons to make your data more interactive and easier to read. To enable the radio buttons you need to either add a new column of data or a new sheet, depending on the chart type.

cc6Go to the Settings tab to change the chart type. You can only switch between charts that have a similar data structure.

cc7Change the colors for each category in your chart. You can use any of the pre-selected colors in the theme or use any color of your choice by typing in the hex code. To learn more about using color in data visualizations, visit our blog post: How to pick the right colors for your chart.

cc8Change the height of each chart. The range goes from 100px to 2000px. Also, we recommend you to always label the axes to help the viewer understand you chart.

cc9You can change the width of each column either by choosing a fixed value or the automatic category width, which matches the column width to the project width.

cc10Go to the Project Settings tab to change the color theme and the width of the project (this will modify all the charts in the project). Business account users can also change the branding and inbound links settings there.

cc11Click on Theme to switch to another color theme for the project (this changes the background, default colors and fonts). Upgrade to a Pro account to unlock more themes.

cc12You can change the overall width of the project from 275 px to 1024 px. You can modify the output size for printing separately under the Download settings.

The Pie Chart

cc13Now let’s check out another popular chart type – the pie chart. We’ll look into the donut chart in particular.

cc14Enable the Legend to show the color legend below the chart. Hovering over the legend also highlights the respective section in the chart.

cc15You can enable static call-outs for all types of pie charts in order to display numerical or percentage values and/or data titles.

cc16The values on the first row of the spreadsheet enable and define the radio buttons as well as the title in the middle of donut chart.

The Line Chart

cc17Now, let’s create a new line chart.

cc18You can enable or disable the grid to remove or add background guidelines to your data.

cc19Enable the Legend to show the color legend below the chart. Enable Data points to show dots on the line.

cc20Enable Reverse axis to flip the values of the chart.

cc21By default the line chart treats the top row as a date. Enable Numeric categories to treat the values as plain numbers.

Contact us to learn more about our paid plans.