Re Steven Ward's message of 27 Apr 01:
> I need to draw a bar/column graph using the following type of data:
>
> ID Group Value
> 1 A 41
> 2 A 42
> 3 B 43
> 4 C 44
> 5 B 45
> 6 D 46
> 7 D 47
> 8 E 48
> 9 C 49
> 10 E 50
>
> X-axis - ID (ie each bar represents one ID)
> Y-axis - Value
> I want to use the group identifier (A, B, C, D or E) to colour each
> of the bars, so the bars can be one of 5 colours.
What you need to do is assign each item of the Value data to one of 5
columns labelled A to E, using a copied formula of the form:
=IF($B19=E$17,$C19,"")
Then create a Stacked Column chart, ostensibly comparing 5 different
series (A to E), only one of which happens to be present in each
column. I think this does what you want.
[I'm sending a demo worksheet to Steven, but not the whole List, as
an attachment.]
Nigel
_______________________________________
Nigel Greenwood
London UK
http://www.elgin.free-online.co.uk/
_______________________________________
|