iepritchard
Board Regular
- Joined
- Jan 9, 2009
- Messages
- 52
Hi All,
I have code in order to automatically make a chart, but I need a slightly more complicated method of choosing the series to be charted.
I need to plot several series on the same graph, but the number of observations in each series depends on options chosen beforehand.
For example, take the data
X Y
A 1 12
A 2 11
A 3 17
A 4 20
B 2 11
B 5 12
B 6 13
C 1 10
C 8 15
I need to plot the separate series for rows with A, B, and C so they can be highlighted in different colours.
Another problem is that the number of rows for each letter eg. A, isn't fixed, so to select the series I need to search all rows for "A" and then select data for the series.
There also isn't a fixed number of series, the number ranges from 2 to 30 series, is it possible to accomodate this..??
Once again I just need the code to select the series with!
Any suggestions would be most gratefully recieved,
Thanks,
Ian
I have code in order to automatically make a chart, but I need a slightly more complicated method of choosing the series to be charted.
I need to plot several series on the same graph, but the number of observations in each series depends on options chosen beforehand.
For example, take the data
X Y
A 1 12
A 2 11
A 3 17
A 4 20
B 2 11
B 5 12
B 6 13
C 1 10
C 8 15
I need to plot the separate series for rows with A, B, and C so they can be highlighted in different colours.
Another problem is that the number of rows for each letter eg. A, isn't fixed, so to select the series I need to search all rows for "A" and then select data for the series.
There also isn't a fixed number of series, the number ranges from 2 to 30 series, is it possible to accomodate this..??
Once again I just need the code to select the series with!
Any suggestions would be most gratefully recieved,
Thanks,
Ian