How to Create a Variable Size Pie Chart
Table of Contents
What is a Variable Size Pie Chart
Also known as a Variable Radius Pie Chart, this type of graph is evolved from a regular single-series Pie Chart, with an additional measure that makes each slice also variable in radius. Numeric labels inside each slice still refer to the initial measure.
The chart looks similar to a Nightingale Rose, but all radial columns have the same width in that case.
Steps to Create a Variable Size Pie Chart
Start Visual Xtractor or Data Xtractor. Connect to a database. Create or design a SQL query. Run the query and check the results.
- Display and enable the Chart query builder.
- Select the numeric column you’d use for the typical pie as Pie Charts – Pie chart.
- Set as Size the other numeric column you want for the variable slice height.
- You may also select a column as Label, whose values will appear as chart legend items.
Variable Size Pie Chart Demo Queries
Look for the ready-to-use Variable Pie Size generated query under the Queries > Demo Queries > Charts > Pie Charts folder. Click on the “add demo queries” command link, if not there.
Remark this looks like a Nightingale Rose chart, but it is not, as long as slices have not all the same angle. However, you may emulate one single-series Nightingale Rose chart with this Variable Size Pie chart by passing a constant value (such as 1) to the Pie column, and showing Size values as data labels.
Customize your Variable Size Pie Chart
- Make the pie chart single-color.
- Choose different drawing styles (such as Concave and Semi-Transparent).
- Show percents or axis labels as data labels inside the pie.
- Click on legend items to hide or show back some slices.
- Creating Variable Size Pie charts in Data Xtractor or Visual Xtractor is fast and easy: after the usual selection of your numeric column as Pie, and an optional Label, use Size for a numeric column you want as second dimension, for the variable slice heights.
- All builtin powerful features of these chart type are common to most other charts: filtering series through the legend items, interactivity, monochrome or grayscale colors, rich axis and data label selections etc.
- Switch to another builtin chart theme, or customize your own, for any possible color or other styles.