Matching Scatter chart data point colour to associated table colour.

Best I can think of is something like this:

It isn't based on the conditional highlighting. The two extra columns use formulas that are the same as the highlighting rules.

C2 =IF(B2<0,B2,"")

D2 =IF(B2>2,B2,"")

Fill down to complete the columns

The Chart:

1. Make a line chart of all three columns.
2. Select the chart
3. Click on Edit Data References
4. Click next to the colored dot above column B in the table
5. In the Format sidebar, go to the Series tab and change the order of this series to 3
6. Repeat steps 4 and 5 for the the other two series, making them 1 and 2
7. Click on the chart, maybe twice, so no particular series is selected.
8. In the Format sidebar give all the series a data point shape and size.
9. Once again click next to the colored dots on the table to select each series individually and individually give them the correct data point colors, no connection lines (except for column B), and whatever other formatting they may need.

Hide columns C and D

mickf wrote:

wanted to know if there is a way to make the associated data points in a scatter chart (XY chart) take the colour of the table value from which they are derived

No, I do not think that is possible.

You can set series colors manually in the style tab, as described.

SG

Hi Mick,

mickf wrote:

Ie, if a particular value in the table is, say, green then the associated data point in the scatter chart is also green.

Not possible. You can change the colour of a whole series, but not individual data points within a series.

Regards,

Ian.

Not sure exactly what you are asking (a screenshot would help) but you can click a series in a chart and set its color in the Style tab under Format in the inspector pane at the right.

There is no automated way for the series to take the color from a table.

SG