Ask Your Question
0

Graphing x vs y but colouring points based on 3rd value

asked 2015-12-08 23:46:49 +0200

Shani92 gravatar image

Hi, I have three columns ( x, y and z). I want to create a graph of x versus y. I want all points with a non-zero value for z to appear red and all points with a zero value for z to appear blue. How would I accomplish this? Thanks.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-03-27 13:43:25 +0200

oweng gravatar image

This can be accomplished by a simple re-organising of the data. The z column is essentially the category label. First sort the data based on the z column. For clarity, consider move the corresponding x and y value pairs, for all non-zero z labels, to a new set of columns.[1] This should result in:

 Zero         Non-zero
 z0, x0, y0   z1, x1, y1

Use an XY (Scatter) chart type with x0,y0 as the first data series and x1,y1 as the second data series. The series will automatically use different symbols and colours.

[1] The downside of doing this is related to data point label display i.e., there are two (z) columns. If this is important perhaps use a range of row to represent each series.

edit flag offensive delete link more
0

answered 2015-12-09 20:49:41 +0200

Regina gravatar image

There exists no direct way to make the color of a chart point depend on the value. You can likely get the task done by a makro, or you generate two helper data series, one for "zero" and one for "non-zero" and display them instead of the original ones.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-12-08 23:46:49 +0200

Seen: 268 times

Last updated: Mar 27 '16