T
Tim
This is pedantic, but what the sponsor is requesting.....
I have set up a chart on a form. Rules dictated from
above say that
Data series 1 must be blue
Data series 2 must be red
Data series 3 must be Orange
Data series 4 must be Grey
Data series 5 must be Yello
OK, so when a record has all these data series, no
problem, the colours are all fine. However, when a record
has no data series 3, the coulours all move down 1, thus
4 becomes orange, 5 grey etc.
How can I lock this? so if a data series is called 'X' it
only ever gets the colour I want it to be?
TIA - realise this is a tricky one
Tim
I have set up a chart on a form. Rules dictated from
above say that
Data series 1 must be blue
Data series 2 must be red
Data series 3 must be Orange
Data series 4 must be Grey
Data series 5 must be Yello
OK, so when a record has all these data series, no
problem, the colours are all fine. However, when a record
has no data series 3, the coulours all move down 1, thus
4 becomes orange, 5 grey etc.
How can I lock this? so if a data series is called 'X' it
only ever gets the colour I want it to be?
TIA - realise this is a tricky one
Tim