Formatting Chart Axes

You can easily customize the chart axes for most chart types in datapine using the Chart Options in the Chart Creator. You may add or hide titles and labels, give them a unique look by choosing different font styles or colors and add a secondary Y-Axis for a better understanding. Follow the steps below to learn how to modify and format the chart axes in the Chart Creator.


Access the Axes formatting Options


  1. Open an empty chart with a click on Analyze and build your chart.
  2. Click on Chart Options in the upper right corner of the Chart Preview to open the X- or Y-Axis Options. You may now open the options to format the X-Axis or Y-Axis of your chart. This will open the Axes Options on the right side of the Chart Creator.

axes formatting options in datapine


Format the Axes Title


datapine displays the name of the field on the Y-Axis as axes title by default. By unticking the checkbox next to Show axis title you can hide the title. You can also add a custom name to your axes by typing a custom label into the textbox below Axis title.


Format Axis Labels


You can show or hide the axis number or data labels by marking the respective boxes in this section. The axis unit dropdown menu lets you alter the measurement of the number labels for the Y-Axis.


Edit the Axes Number Format


In this section you may specify your number labels in more detail. Add symbols like € or $, define a number format and the number of decimal places that should be displayed. Note that the Axes Number Format of the Y-Axis also affects the data labels on your chart.


Change the Axis Scale


The Y-Axis scale can be customized by defining a minimum, maximum and interval of your Axis. Simply type in the thresholds you wish to use into the respective boxes.


Add a secondary axis


Different metrics often require different scaling. Let’s assume you would like to display the running total and the growth rate of your turnover in one chart. Without a second scale it might be difficult for your audience to evaluate the two metrics due to the large discrepancy in size. For such cases it is useful to display both metrics on individual axes. The following steps will demonstrate how to add a secondary axes to your charts in datapine.


  1. In your chart, right click on the data series you wish to display on the secondary axis.
  2. In the context menu of the data series select Show on secondary axes. datapine automatically creates a default secondary axis for the selected variable.
  3. With a click on Chart Options in the right upper corner of the chart preview you can now access the formatting options for the secondary Y-Axis.

how to add a secondary axis to a chart in datapine