Home » Categories » CHARTrunner

CR: Label your X-Axis with more than one identifier

Revision Date: 2009-01-29

Problem:

I spoke with a customer the other day who wanted multiple labels along the x-axis of his control chart. His data set and original chart looked like this:

Notice how the x-axis labels contain ONLY the date column? He also wanted the Batch number as part of the x-axis label. In the chart definition form, you can select only a single identifier as the label as shown below:

Solution:

At first I did not think we had a solution. However, the answer lies on the data definition tab. The customer had defined the chart to look directly at the data table as shown below:

This works well for most chart definitions. However, if you are willing to get your hands dirty with a little custom query work then you too can solve this problem! C’mon... give it a try it is not as painful as you think. Here is the SQL custom query that solved the problem:

Select [Date] & " - " & [Batch] as DateAndBatch, * from [Sheet1$]

Using the custom query gives you a derived column named DateAndBatch. Now, you can setup the data definition form like this:

This allows you to select DateAndBatch as an x-axis label on the control chart tab. The result is a chart like this:

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Error “External table is not in the expected format” using Excel 2007 workbook
Viewed 4036 times since Wed, Oct 14, 2009
CR: CR1.1 - Charts in the Chart Workspace do not print all of the charts
Viewed 2044 times since Fri, Nov 9, 2007
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3690 times since Fri, Nov 9, 2007
CR: Charts not working on a new PC
Viewed 2000 times since Fri, Nov 9, 2007
CR: Charts with large amounts of data
Viewed 1914 times since Fri, Nov 9, 2007
CR: Installing CHARTrunner disables desktop wallpaper
Viewed 2059 times since Fri, Nov 9, 2007
CR: Time Display
Viewed 2075 times since Fri, Nov 9, 2007
CR: Collating sequence not supported
Viewed 2626 times since Tue, Dec 11, 2007
CR: A simple query pattern for summarizing raw data
Viewed 2914 times since Tue, Oct 6, 2009
CR: CHARTrunner and Open Office
Viewed 2386 times since Fri, Nov 9, 2007