Chart Combinations

In datapine you can combine two or more types of visualization in one chart without changing the original visualization type of your chart. This is useful when displaying multiple metrics at once or if you wish to highlight some data sets.


How to set a different visualization for a data series


The visualization type for the individual data series in your charts can be changed using the right click of your mouse. With a click on the data series you can access the quick series options. Then hover over Change series type to select the preferred chart type.


 illustrating combination of column and line chart


Custom chart types


Heat maps


Heat maps are a special form of tabular presented data using a custom-defined color range. In datapine you can turn any table into a heat map using the Table Style Options. Applying the background gradient option makes the data much more understandable and helps to highlight variations and outliers in larger data sets.


heat map created with datapine


How to create a heatmap


  1. In the Chart Creator, select Table as chart type.
  2. First, start building your table by adding fields from your data sources to the Measures & Dimensions or run your SQL query in the SQL box.
  3. Then click on Table Options in the right upper corner of the chart preview and select Table Style from the dropdown menu. In the Chart Options to the right below General Options, click on the dropdown for 2nd Color and choose Gradient. Below define the color range from lowest to highest and click on Apply.


Pie chart maps


Using a map chart for you geographical data is an appealing visualization, however pairing this chart type with pie charts will allow you to breakdown the data for each country and add more information for your audience. To create a pie chart map, add any additional categorical data field to Decompose, just as we did below to breakdown customers per country by the marketing channel.


map pie chart created with datapine