K
Keith Kaminetzky
I hope this is the correct forum.
I have a set of data as follows which is charted using a vertical bar chart.
Each product has three possible costs depending on customer incentives. The
charts initial set up has the three from group A color shaded red, then
the three from group B color shaded blue, Group C's three elements are
shaded green. As the data shows Group a is the lowest cost then B then C.
When we put a customer incentive on one group say B som of the costs
actually price below those of A. I want to then resort the underlying data
so that the the chart always goes from lowest cost to highest but that if
group B items are now lower than group A you'd easily pick up the visual cue
from the chart without having to get up close to read the fine print. When
I try this the 1 -2 itemes from group B do in fact sort to the correct
location however they pick up the group A color shading an the group B picks
up the Group A. I end up with three red then three blue then three green
bars when I want to see the interspersing of the colors. Thoughts and or
ideas or a redirect to the correct group is appreciated. KK
Original data before discount is applied
A1 A2 A3 B1 B2 B3 C1 C2 C3
3 4 5 7 8 9 11 12 13
Data Layout sorted in price order by product with each group B product
having a $3 discount
A1 A2 B1 A3 B2 B3 C1 C2 C3
3 4 4 5 5 6 11 12
13
I have a set of data as follows which is charted using a vertical bar chart.
Each product has three possible costs depending on customer incentives. The
charts initial set up has the three from group A color shaded red, then
the three from group B color shaded blue, Group C's three elements are
shaded green. As the data shows Group a is the lowest cost then B then C.
When we put a customer incentive on one group say B som of the costs
actually price below those of A. I want to then resort the underlying data
so that the the chart always goes from lowest cost to highest but that if
group B items are now lower than group A you'd easily pick up the visual cue
from the chart without having to get up close to read the fine print. When
I try this the 1 -2 itemes from group B do in fact sort to the correct
location however they pick up the group A color shading an the group B picks
up the Group A. I end up with three red then three blue then three green
bars when I want to see the interspersing of the colors. Thoughts and or
ideas or a redirect to the correct group is appreciated. KK
Original data before discount is applied
A1 A2 A3 B1 B2 B3 C1 C2 C3
3 4 5 7 8 9 11 12 13
Data Layout sorted in price order by product with each group B product
having a $3 discount
A1 A2 B1 A3 B2 B3 C1 C2 C3
3 4 4 5 5 6 11 12
13