display guage charts for Dim 1 based on selections for Dim 2

[mazacini]

I have values for 25 dimensions for which I need individual guage charts. (Dim 1.below)

The 25 dimensions share 2 common value fields.

The first of these values will be the basis of the guage chart expression.

The second will be used for the guage chart Reference Line.

My question: Is there a way that I can create the guage charts "on the fly" based on selections of Dim 2.

ie

If I select A from Dim 2 values, can I display only the 5 guage charts for each of the associated Dim 1 values

If I select F from Dim 2 values, can I display only the 2 guage charts for each of the associated Dim 1 values

Dim1	Dim2
1.1	A
1.2	A
1.3	A
1.4	A
1.5	A
1.6	A
2.1	B
2.2	B
2.3	B
2.4	B
2.5	B
2.6	B
3.1	C
3.2	C
3.3	C
3.4	C
4.1	D
4.2	D
4.3	D
4.4	D
5.1	E
5.2	E
5.3	E
6.1	F
6.2	F

[pover]

Here are my thoughts for what they´re worth. 

Embedding the gauge chart in a simple table with Dim1 as the dimension is an option as long as all the gauge have the same color boundaries and no reference line.  Making a gauge chart trellis chart has the same limitations.  They have to be separate objects and you can only make separate objects on the fly using a macro.

Karl

[mazacini]

Thanks Karl

Its the reference line that is the reason for using guage charts - I use it as a line symbol as an alternative to a combo chart because line symbol not available in combo chart.

As I cannot say for certain that your answer is correct, I will instead mark it as helpful

Thanks

Joe