Hi,
Hope someone can help.
Please see the below example of a table I want to use to make a X Y graph: [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 344"]
[tr][td][/td][td]X
[/td][td]Y
[/td][td][/td][/tr][tr][td]Fruit
[/td][td]WIDTH (cm)
[/td][td]LENGTH (cm)
[/td][td]VOLUME (cm2)
[/td][/tr][tr][td]Apple 1
[/td][td]5.6
[/td][td]5.4
[/td][td]30.24
[/td][/tr][tr][td]Apple 2
[/td][td]5.5
[/td][td]5.5
[/td][td]30.25
[/td][/tr][tr][td]Apple 3
[/td][td]5.9
[/td][td]5.5
[/td][td]32.45
[/td][/tr][tr][td]Apple 4
[/td][td]6.2
[/td][td]5.6
[/td][td]34.72
[/td][/tr][tr][td]Strawberry 1
[/td][td]2.1
[/td][td]2.5
[/td][td]5.25
[/td][/tr][tr][td]Strawberry 2
[/td][td]2.3
[/td][td]2.7
[/td][td]6.21
[/td][/tr][tr][td]Strawberry 3
[/td][td]2.2
[/td][td]2.5
[/td][td]5.5
[/td][/tr][tr][td]Strawberry 4
[/td][td]2.2
[/td][td]2.4
[/td][td]5.28
[/td][/tr][tr][td]Lemon 1
[/td][td]4.1
[/td][td]5.3
[/td][td]21.73
[/td][/tr][tr][td]Lemon 2
[/td][td]4.3
[/td][td]5.4
[/td][td]23.22
[/td][/tr][tr][td]Lemon 3
[/td][td]4.4
[/td][td]5.5
[/td][td]24.2
[/td][/tr][tr][td]Lemon 4
[/td][td]4.2
[/td][td]5.6
[/td][td]23.52
[/td][/tr][tr][td]Plum 1
[/td][td]3.3
[/td][td]4.8
[/td][td]15.84
[/td][/tr][tr][td]Plum 2
[/td][td]3.6
[/td][td]4.9
[/td][td]17.64
[/td][/tr][tr][td]Plum 3
[/td][td]3.4
[/td][td]4.8
[/td][td]16.32
[/td][/tr][tr][td]Plum 4
[/td][td]3.3
[/td][td]4.7
[/td][td]15.51
[/td][/tr]
[/TABLE]
So it is simple enough to plot each fruit on a X Y graph, but what I want to know is there a way that I can colour the plots/data series on the graph according to the type of fruit it is (ie lemon is yellow, Plum is purple etc) but not doing this manually for each plot on the graph.
I ask as I am try to do something where there is over 1,000 plots to go on the graph so cannot do it manually for each one.
Thanks