This is a question about using charts in Numbers and color coding individual data points in a series.

I have two series of data (blood pressure readings) that I plot in a chart. The series may contain multiple readings made at different times on a day, or there may be a single reading.

Is there a way to color code the data points in each series to indicate which part of the day the reading was taken? e.g. 6am-10am = purple, 10am-2pm = orange, 2pm-6pm = blue, etc.

The reason I want to do this is to distinguish between readings taken before and after taking medication.

Here's the chart


Welcome to Ask Different!

Unfortunately, I am not aware of an easy way to do what you are asking for in Numbers. Below is how it could be done in case you wish to do it no matter how:

enter image description here

In the example above, the data for both high and low blood pressures are shown in three separate columns, assuming there are three time zones in a day to be highlighted. I used the formula shown in the picture to separate the readings by time zone (you can do all of the separation manually if you like but doing it all manually might turn out to be extra tedious and it might be cumbersome to apply new time zone limits if you change your mind). Of course, the formula is slightly changed for each column so that it refers to the correct cells. In addition, the first non-zero reading in each second and third columns is overwritten manually with the number to its left to get continuity in chart lines (the second 73, 72, 143 and 142).

I used the Format -> Style sidebar menu option to set the high and low lines with the same color after selecting the respective part of each line as shown in the picture below:

enter image description here

I used a relatively old version of Numbers (6.1) to produce the table and the chart above but I reckon you would have no trouble producing them as well in case you have a newer version.

Hope these help!

  • Wow! I'm amazed that you took the time to figure out a solution. Thank you very much, I really appreciate your help.
    – FredB
    May 6 at 1:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .