How to Create a Status Chart
Table of Contents
What is a Status Chart
To visualize the on/off status of several engines in time, you have four variables:
- the engine names, to use as Y axis labels.
- a common time series on the X axis.
- the actual measure as (x, y) points on the plot.
- and the on/off data labels to associate with each state.
Achieve this by adding the status labels as Category to a typica Range Bar Chart.
Several people – including myself – looked for the same kind of chart on the net, and the solutions have been either absent, or too complex (like using a Gantt chart), or simply puzzling.
I called it Status Chart from the initial example presented before. But this type of chart may be used as well in other kinds of scenarios, as the one below. Which is indeed one of project management. And where the Gantt charts may be used as a solution too.
Remember that this so-called Status Machine chart type is simply a Range Bar Chart with a Category.
Steps to Create a Status 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.
- Set your start dates as Bar Charts – Bar Start, and your end dates as Bar.
- Add a Label column for the Y axis labels.
- Set as Category the column with the status labels, and show categories as labels.
- Click on Group same text values together, to concatenate and overlap the intervals.
- Switch rows with columns to show either horizontal bars or vertical columns.
Status Chart Demo Query
Look for the ready-to-use Status Chart generated query under the Queries > Demo Queries > Charts > Category Charts folder. Click on the “add demo queries” command link, if not there.
Customize your Status Chart
- Switch rows with columns, to display vertical columns.
- Change the drawing style.
- Hide the plot lines.
- Show thin lollipop bars.
- Hide the data labels.
- Show markers.
- Creating Status Charts in Data Xtractor or Visual Xtractor is fast and intuitive enough: you add a Category column – with your “status” labels – to a typical Range Bar Chart.
- Group same text values together.
- Project management scenarios may use Gantt charts with a similar effect.