How to Create a Target Diagram

Table of Contents

What is a Target Diagram

An ordered list of names or descriptions could be graphically displayed using a pie-based Target Diagram. Some other way to do it is with a Pyramid Diagram.

Switch rows with columns and you get another different layout for this chart type, as it follows:

  1. Categorized Target Diagram (by default) – as pie with same-size slices.
  2. Target Diagram – as nested pies or circles, or bulls-eye.

Each textual information is represented within a slice or circle of the same approximate size. Remark that using a numeric column instead will cause each slice size to adjust accordingly. This is a less restrictive diagram, as most of the charts require numeric columns.

Steps to Create a Target Diagram

Start Visual Xtractor or Data Xtractor. Connect to a database. Create or design a SQL query. Run the query and check the results.

  1. Display and enable the Chart query builder.
  2. Select a textual column as Pie ChartsPie chart.
  3. Swap rows with columns to get the bulls-eye view.

Categorized Target Diagram Demo Query

Look for the ready-to-use Target Diagram generated query under the Queries > Demo Queries > Charts > Pie Charts folder. Click on the “add demo queries” command link, if not there.

Target Diagram

Generated demo queries must work for any database, with no restriction. They use constant values generated on-the-fly and your database SQL engine, but do not depend on data from your tables, and never alter your database in any way.

Customize your Categorized Target Diagram

  1. Collapse the legend, as long as all labels appear on the chart anyway.
  2. Make it multi-color.
  3. Switch to 3D and show is as semi-transparent.
  4. Explode all slices.
  5. You may also click on legend items to hide or show back some segments.
  6. Or you can swap rows and columns for a more traditional target diagram.

Custom Target Diagram


  • Creating a Target Diagram in Data Xtractor or Visual Xtractor is fast and trivial: set any data column with textual information as Pie, and that’s it!
  • Initial view is Categorized, but you may Switch rows with columns for the bulls-eye layout.
  • 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.