Hello i've posted this problem on here before but now i got a different question.
I am trying to create a chart with 4 bands (A - D) and within each bar (the bands) there are to be 6 segments (1-6).
I cant get the segments to order correctly (1 - 6) is now (1-4 and then 6-5).
I've now come to realise that the reason it does not order correctly it is not neccessarily the case that in each band there will be records ranging from segment 1 - 6 maybe just 2,3,6.
Which is why the segment order is out of sync.
I need a formula that will have 6 values (1-6) to put in the on change field.
For example my chart expert looks like -
on change of -
(1)band
(2)PCtotal
Show sum of -
@CountPCTotal
I need a formula with the values 1-6 to be in the place of PCtotal.
I tried using an array but i coudn't select the array formula - does anyone have any ideas?
Thanks in advance
I am trying to create a chart with 4 bands (A - D) and within each bar (the bands) there are to be 6 segments (1-6).
I cant get the segments to order correctly (1 - 6) is now (1-4 and then 6-5).
I've now come to realise that the reason it does not order correctly it is not neccessarily the case that in each band there will be records ranging from segment 1 - 6 maybe just 2,3,6.
Which is why the segment order is out of sync.
I need a formula that will have 6 values (1-6) to put in the on change field.
For example my chart expert looks like -
on change of -
(1)band
(2)PCtotal
Show sum of -
@CountPCTotal
I need a formula with the values 1-6 to be in the place of PCtotal.
I tried using an array but i coudn't select the array formula - does anyone have any ideas?
Thanks in advance