Column Chart

[jeffv]

Quick question... (or hopefully so)..

I have dummied down to a simple example of data with three columns:  Sector, Part, Count with a few rows of data.

I want to create a column chart showing the bars of count for each of the parts in a sector.  In this case of two charts as I want each chart to show a sector.  I have included my simple workflow with data.  Now my question... how do I identify sector in each chart?  Is there a way in a title/subtitle the value of the field I have grouped by (ie sector?).

Thanks for any insight or pointers where I can find the answer.

All the best,

Jeff

[CharlieS · Accepted solution]

@jeffv

When you select a field in the Grouping settings, notice that the fields selected are passed to the Output along with the Chart field. Use a Report Text tool to create a title using that field. 

Solution attached.

[jeffv]

Thanks...  didn't see those fields.  Just what I needed.  Thanks for your help!