JoshMarquart
IS-IT--Management
I have a table that has sequence number, description, type, and rating.
Seq# Descr Type Rating
1 Leads A 5
1 Lead R 5
1 Leads S 4
1 Lead A 4
2 Follow A 3
2 Follow R 3
etc...
I am trying to do a stacked bar chart but the X axis shows each Rating value twice 1 1 2 2 3 3 4 4 5 5
Group 1 is the Sequence Number
Group 2 is the Type
The goal is to have one graph for each sequence number. On each graph, all the types are shown with Min, Avg, and Max values. The trouble is that the differing Descr seems to cause the sequence number to show up twice, even though the Descr field is not used.
Any ideas?
Seq# Descr Type Rating
1 Leads A 5
1 Lead R 5
1 Leads S 4
1 Lead A 4
2 Follow A 3
2 Follow R 3
etc...
I am trying to do a stacked bar chart but the X axis shows each Rating value twice 1 1 2 2 3 3 4 4 5 5
Group 1 is the Sequence Number
Group 2 is the Type
The goal is to have one graph for each sequence number. On each graph, all the types are shown with Min, Avg, and Max values. The trouble is that the differing Descr seems to cause the sequence number to show up twice, even though the Descr field is not used.
Any ideas?