Create a dumbbell chart in everviz
Follow the steps in this article to create a dumbbell chart in everviz.
Dumbbell charts are great for seeing the difference between a category’s two data points, such as its maximum and minimum values. A dumbbell chart plots a line between these two values so that a viewer can quickly see the difference between a category’s two values in relation to other categories’ values plotted on the chart.
The example we’ll create lets us see how the maximum and minimum sales performance data foa sales team. The dumbbells let us see the range between the two poles which lets us deduce that salespeople with smaller dumbbells are the more consistent performers regardless of the percentage of their target they’re hitting. This gives us more information about a salesperson’s performance than just a blunt percentage.
To create a dumbbell chart:
- Launch the project wizard and select Chart to launch the chart wizard
- Select Dumbbell from the Chart type section to the left of the chart wizard’s screen. Notice that the preview pane changes to reflect the chart type you’ve chosen
- Click Next to move to the Data step where you can enter the data for your chart
- Click the top-left cell (A1) in the data table and press CTRL+A to select all the data in it
- Press the delete key to remove the example data
- Copy this example data and paste it into the data table at the top-left cell (A1). You’ll see the newly added data reflected in the preview chart
- Click Next to move to the Design screen where you can choose a theme for your chart. Click an available theme to see how it looks, or stick with the default theme
- Click Next to move to the Text & Annotations screen where you can add contextual information to your chart, such as a title, axis labels and a caption
- Click Next to move to the Save or Publish screen where you can save your chart for later amendment or use, or publish your chart
- Alternatively, you can click the Continue in Editor button to edit the chart further with more granular options