How to create a 2-axis chart with systolic, diastolic, and heart rate on Numbers for the same date-time?

Hi Jorge,

This is a 2D 2-Axis graph. The table has 3 Header Columns and 2 Header Rows.

I moved the medicine data to a column on the far right so as to avoid those blank rows that were stopping the graph lines joining up.

I discovered that a 2-Axis graph considers the first Y column to be Y1 and subsequent Y columns to be Y2. Therefore I moved the BPM column to the left of Systolic and Diastolic. I hope that makes sense!

Let me know if you want to change the scale of Y1 or Y2 axes.

Regards,

Ian.

Yellowbox wrote:

Let me know if you want to change the scale of Y1 or Y2 axes.

Here's how.

I discovered that a 2-Axis graph considers the first Y column to be Y1 and subsequent Y columns to be Y2. Therefore I moved the BPM column to the left of Systolic and Diastolic.

No need to move columns. Just poking around, I found that clicking on a Series to select it, we get this option to change which Y Axis:

Regards,

Ian.

Hi Jorge,

I reproduced the data table the way you want it.

Three Header Columns (Dia, Column C must be a Header Column for a 2D 2-Axis graph).

There are gaps in the table columns. That means the graph lines do not join up. Numbers does not fill gaps in graphs (Numbers would have to guess) and we can not change it.

Row 2 (Maximums) has become added to the legend. Either moved that row to a Footer or edit the legend.

One good thing: The graph has expanded the X axis to Day 7 to match the table. If your table goes for a whole month, the graph will be ready!

Goodnight from Australia.

Regards,

Ian.

Hi Jorge,

Thank you for your reply. Here is my latest attempt with a 2D 2-Axis graph and I do think we should use a 2D 2-Axis graph, rather than a using a 2D - Line chart.

I enlarged your Table "Pressão Sanguinea-bpm-droga" to 30 Dia for November. Now the graph is sufficiently wide to allow 30 Dia on the X Axis.

I moved your BPM column back to where you wanted it, because we now know how to force a column to plot on Y1 Axis or Y2 Axis 😎.

"I also followed your advice of having the first 3 columns as Header Columns, without knowing why, but expecting that the chart will pick up only the 3rd as the ‘x value’; I liked that I could maintain the 2 first rows as Header Rows."

That is important. The X values must be in a Header Column for a 2D Line graph.* (see edit below) "Trust me!" said the politician.

To create this graph, I selected column C ("Dia") and then I held down the command key and selected columns G, H, and I (“Sistólica”, “Diastólica” and “BPM”)

Questions:

I set the scale of Y1 (mm Hg) and Y2 (BPM) as 0 to 140.

We can easily change the range of Y1 and Y2

Thank you Jorge for this stimulating challenge that has kept my brain alert! I am always happy to help.

Please reply with questions.

Kind regards,

Ian.

*Edit: my mistake. I should have said The X values must be in a Header Column for a 2D 2-Axis graph. Oops!

Ian,

The ‘Ação/Action’ column now has only 2 options (Do not take the drug/Take the drug (1/2 or full)) - depending on the readings of the BP, having the possibility of taking it more than once a day (I hope not); so, no more gaps for the chart;

I also followed your advice of having the first 3 columns as Header Columns, without knowing why, but expecting that the chart will pick up only the 3rd as the ‘x value’; I liked that I could maintain the 2 first rows as Header Rows.

After, I selected the 4 columns for the chart: “Dia” (=Day(Date/Time)), “Sistólica”, “Diastólica” and “BPM”) — and it did not matter if I put the “BPM” before the 2 of the BP;

Then, I pressed the ‘Chart’ button and chose the Type of Chart: (1) the ‘2D 2-axis’ give me 2 references for the ‘y values’ (30 (numbers of days in November), and that was considered the first value of the ‘Y value’ (which it is not) — so, it is a line in 45 º —,  and 160 (to include the Maxim value of my data that was 144); the other data (Sys, Diastolic and BPM) are shown as vertical lines (No fun.); but if I changed the chart option to ‘2D Line’, it shows just 1 reference for the ‘y value’, that is 160 and this is ok, but the resulting graph has 2 trades-off: the same line of the “Dia” as an ‘y value’ (which it is not) & it is conceding the “Dia” as the number of the row.

I played with this for longer, to better understand the software’s modus operandi.

I thought that setting 3 Header Columns (all related to a ‘Date/Time’) would let it suppose that this would be the ‘x value’; consequently the other 3 columns that I would select would be 3 different ‘y values’, namely “Sistólica”, “Diástólica” and “Heart Rate”. Reading from what you wrote I think that you consider these 3 ‘y values’ as only 2, because the BP has 2 of the 3.

Anyway, I played a little more with the charts, and at some time I did not select the “Dia” (=Day(Date/Time)) and I selected only the 3 columns of ‘y values’, and it worked —using the ‘2D - Line’ type of chart.

I was able to include the former BP references — 120 mmHg x 80 mmHg; nowadays the doctors changed those to 110 mmHg x 70 mmHg (so they can have more customers), while since I am in my 8th decade, I may put that references to 130 mmHg x 90 mmHg.

So, this last chart just needs to correct the bottom line of the ‘x values’ to the natural numbers {1, 2, 3, …, 30}, since we are in November; I may add a division of the ‘y values’ in lines of 10 mmHg, but that can wait.

Best regards,

Jorge Lucas (the guy from Rio Grande do Sul)

Hi Jorge,

I gave up on the Numbers 2-D 2 Axis graph.

Is this what you want? I started with a 2-D Scatter Plot and added Reference Lines (from your yellow Header Row)

Here is a graph for Mr Nobody.

Now another 2-D Scatter Plot for heart rate (BPM)

X axis is Data/Hora. Y axis is BPM.

We can overlap the two graphs to make them appear as one. But first, some edits to those graphs.

It is late here, more tomorrow.

P.S. Thanks for the screen shot of my reply in December 2025. Please post a link because I have forgotten how I created that reply!

Ian.

Just to ensure you get a new email notification,

*Edit: my mistake. I should have said The X values must be in a Header Column for a 2D 2-Axis graph. Oops!

Ian

Jorge wrote in an earlier reply:

"the other data (Sys, Diastolic and BPM) are shown as vertical lines (No fun.)"

Hi Jorge,

Click on a Series and choose Lines instead of vertical lines.

Regards,

Ian.

Hi Jorge,

Yellowbox here! Can you give a link to that terminated discussion? I can't find it. I can't remember my reply to you.

Regards,

Ian.

Edit: Or, can you post a screen shot (made-up data) of your data table? That will help us to see what you see. Ian.

And your solution at that time was the one I am posting mow. The problem is how to replicate that, since your SS shows only the columns that are needed for the chart, and mine has all that I need for the big picture.

A longer way would do another SS -- for each month --, to have only the data needed for that graph, but this would not value the hassle.

Hi Jorge,

Thank you for the screen shot of your data. I am sorry for my late reply. I am still thinking about how to convert that table into something that Numbers can use to create a chart (graph, in Australian language 😉).

The rows that contain this:

may cause gaps in the graph (Numbers does not make "bridges" over missing data).

I suggest another column to record your medications. I have guessed when those medications are taken.

My table is an absolute guess (and a mess), and applies to nobody.

Well, let me make clear what I have in mind.

This, like I said when I post it, is a duplicate post -- because the original from 2005 was terminated and your reply was for a Mac, while at that time my Mac was not working and I had the SS on an iPhone.

The first row has the name (and maybe the unit); the second row has the Max value of each column (from 'E' to 'L') and this (only if is unavoidable) I could put at the bottom; the third row has the values that should be used to construct the chart and these are in the columns: 'C', that I named "Dia" (using the function 'Day(B)' on each of "Data/Hora", i.e., "Date/Time"); 'H' (Systolic), 'I' (Diastolic) and 'J' (Heart Rate, in bpm).

The extra problem is (I suppose) that they are not in adjacent columns, and if I changed the order of the columns I lost the big picture that I got the way they are now. I will post another screenshot with the SS unlocked, so you would not to guess anything.

If there is a way to do this, and you have time to write the steps, I will thank for that; if you can not, I thank you for what you had already done.

And enjoy the summer that is approaching! (we both live in continental countries, very far apart but we share the latitude; so we share the same seasons of the year).

Note: in your new reply, there was a chart (?) that was substituted by a "?".

Ian, I posted the explanation of my SS in the wrong place: it should be just before the last screenshot, but was placed very much before.

Please, look for October 31, 09:11, that starts with this: "Well, let me make clear what I have in mind."

Sorry for this extra inconvenience.

And about that row that indicate if I got the drug, or did not get it, is, in fact, just 1 cell of the 'column D': this is the action (ação) that will depend on the readings of the BP, in the former row, because there is nothing written in the subsequent cells of the same row. The text expands to the other cells to the right. If this affects the construction of the chart, I can substitute it by a list of options, like: "no drug", "half a 20 mg tablet", "1 full 20 mg tablet". 

Hi Jorge,

Jorge Lucas wrote:

Well, let me make clear what I have in mind.

This, like I said when I post it, is a duplicate post -- because the original from 2005 was terminated and your reply was for a Mac, while at that time my Mac was not working and I had the SS on an iPhone.

Your profile in this new question shows MacBook Air 13″, macOS 27.0

OK, I am also on a MacBook Air, so I will answer as a Mac user.

The first row has the name (and maybe the unit); the second row has the Max value of each column (from 'E' to 'L') and this (only if is unavoidable) I could put at the bottom; the third row has the values that should be used to construct the chart and these are in the columns: 'C', that I named "Dia" (using the function 'Day(B)' on each of "Data/Hora", i.e., "Date/Time"); 'H' (Systolic), 'I' (Diastolic) and 'J' (Heart Rate, in bpm).

OK, I will work on it.

The extra problem is (I suppose) that they are not in adjacent columns, and if I changed the order of the columns I lost the big picture that I got the way they are now. I will post another screenshot with the SS unlocked, so you would not to guess anything.

• You can select non-adjacent columns on a Mac with command click.
• A screenshot of an unlocked table is still a picture. It is not an interactive SS.

Note: in your new reply, there was a chart (?) that was substituted by a "?".

Yes, sometimes this forum software throws a "hissy fit" and posts a "?" instead of a screen shot.

Here are the screen shots.

The 2 graphs overlaid:

The two graphs separated:

I realise that is not an answer to your question.

Thank you for the screen shot of your table Oct 31, 2026 11:16 PM  (Australian time!)

More to come. Regards,

Ian.

Hello again Jorge,

Jorge Lucas wrote:

And about that row that indicate if I got the drug, or did not get it, is, in fact, just 1 cell of the 'column D': this is the action (ação) that will depend on the readings of the BP, in the former row, because there is nothing written in the subsequent cells of the same row. The text expands to the other cells to the right. If this affects the construction of the chart, I can substitute it by a list of options, like: "no drug", "half a 20 mg tablet", "1 full 20 mg tablet". 

I do not know how to plot a graph when data are interrupted by rows of text that are non-relevant to the numbers.

I do suggest an extra column for drugs. Then the data for systolic, diastolic, HR, are contiguous.

Still thinking about your goal!

Regards,

Ian

Hi Jorge,

My suggestion for your table:

However, we need to create two graphs:

• dia versus Sistólica and Diastólica;
• dia versus BPM

then we overlap them!

I will sleep and keep going tomorrow

Zzzz.

Ian.

Ian, 

I am already ashamed of all this work I am giving to you.

Some extra info:

1) in some place I referred that the original post was in 2005, but in reality was 2025:

2) the 2 first rows of my SS were 'header rows'; the first (filled in grey) are the names of the columns (with or without the unit); and the last row is the 'footer row', with only 1 data (the number of days I did not use the drug);

3) you suggested me to move the column related with the drug; instead, I changed that column to a pop up menu with 4 options: 'Medições:','Nenhuma droga', '1/2 comp. Benicar HCT 20 mg + 12.5 mg' and '1 comp. Benicar HCT 20 mg + 12.5 mg'; I also chose the size of 8 pt and I added a rule -- that should turn the text red when it contains the word "comp."; I filled the all column and it appeared that it was everything right.

But problems occurred: just to check if what I did was working, I selected all the inputs I did from the 3rd row to the last (before the footer row) and "Clear All"; then I tried to insert some data again, but the pop up menu was gone; the file quitted several times (signalling that something was wrongly done).

So, I spent hours doing those things and it did not work.

Maybe I should use these 4 options of the pop up menu “without using a pop up menu”: in the beginning of each month, I listed the four in that column and each time I need one, I copy and paste. What do you think about this?

About all the things you showed me, what I found most interesting was the first one, from 2025.

That solution has, in 1 graph, the 3 measures I got each time I use the machine; the systolic pressure, the diastolic pressure and the heart rate.

And, because I am a runner, my bpm (at rest) is low -- which means that the part related to the heart rate will not mix with the blood pressures. And, although the unit of the BP are different of the unit of the HR, there is no reason to have different reference numbers in the graph.

I also liked your idea of substitute the ‘Date/Time’ for only the “Day”, using a formula for that; this simple change reduce substantially the identification of the ‘x value’ on the graph.

If you take a look on the 2 graphs that you put together, they are in different scales and they do not offer a good picture because of this.

Best regards,

Jorge Lucas (Lucas is a second name, and I am saying this because the moderator is always deleting this, because the privacy)

Jorge Lucas wrote: If you take a look on the 2 graphs that you put together, they are in different scales and they do not offer a good picture because of this.

Hi Jorge,

The 2 graphs are in different scales because Sistólica and Diastólica have the units of mmHg (pressure).

BPM has the units of rate (beats per minute).

I do not understand why these should be the same scale.

Jorge Lucas wrote:

Best regards,

Jorge Lucas (Lucas is a second name, and I am saying this because the moderator is always deleting this, because the privacy)

I understand that your full name is Jorge Lucas. I do not know why the moderators are moderating your signature.

Kind regards to Jorge Lucas (your screen name as in your profile).

From Yellowbox (my screen name) alias Ian (my first name as always).

Ian.

Hi Jorge,

My reply to you has disappeared.

Jorge Lucas wrote:

If you take a look on the 2 graphs that you put together, they are in different scales and they do not offer a good picture because of this

Here I go again:

The different scales are because Systole and Diastole have units of mm Hg.

Heart rate has units of beats per minute.

They have different scales, that is why we need a 2-axis graph (Y1 and Y2).

Regards,

Ian.

Ian,

More extra info, before a big “Thank You”:

Jorge Lucas is not my full name: it has a “de” and the ‘Family Surname”;

There are no such a formula between the last reading of the BP and the time to take a drug (in the case I take it);

 I did not click ‘yet’ in the ‘Helpful’ Button because I was waiting for that first solution of December 2025 — in the form that I was dreaming for, i.e., that it was constructed   directly in just 1 graph, with each ‘x value’ (reduced to the ‘Day(B)’) having 3 ‘y values’ (Systolic Pressure, Diastolic Pressure, Heat Rate) but the ‘magic bullet’ may not even exist because you sent 2 or 3 new solutions where you got 2 graphs overlaid;

The reason I kept dreaming with this magic solution is because I am a (retired) Math High School teacher, and in a graph of a function, the points (x,y) are calculated in a way that for each ‘x value’ there is only 1 ‘y value’ and in each of your 2-overlaid-graph solutions, the graph for the BP had, already, 2 ‘y values’ for each ‘x value’, and so, I thought, if Numbers permits this, it can permit that a ‘x value’ have 3 ‘y values’ (the magic solution);

I already recognised that “I replied to a message in the wrong place”  — and that turned the communication between us very confused, because out of order; and because of some things you said, I believe that you did not see some of the things I wrote. So, I will repost them:

              And, because I am a runner, my bpm (at rest) is low -- which means that the part related to the heart rate will not mix with the blood pressures. And, although the unit of the BP are different of the unit of the HR, there are no reasons to have different reference numbers in the graph, because the ‘HR’ number will be below the ‘Diastolic Pressure’, that is already below the ’Systolic Pressure’; but if you build 2 graphs separately, and mixed then later, an ‘HR value’ of 55, for example, can be of the same size of a ‘Systolic Pressure value’ of 150. I know that you set the ranges for each of those ‘y values’, but all of this lose the interesting magical thing of a Math graph: the ability to “see the solution”, at a glance;

              You suggested me to move the column related with the drug; instead, I changed that column to a pop up menu with 4 options: 'Medições:','Nenhuma droga', '1/2 comp. Benicar HCT 20 mg + 12.5 mg' and '1 comp. Benicar HCT 20 mg + 12.5 mg'; I also chose the size of 8 pt and I added a rule -- that should turn the text red when it contains the word "comp."; I filled the entire column and it appeared that it was everything right.

But problems occurred: just to check if what I did was working, I selected all the inputs I did from the 3rd row to the last (before the footer row) and "Clear All" them; then I tried to insert some data again, but the pop up menu was gone; the file quitted several times (signalling that something was wrongly done).

So, I spent hours doing those things and they did not work.

Maybe I should use these 4 options of the pop up menu “without using a pop up menu”: in the beginning of each month, I can list the four in that column and each time I need one, I copy it and paste it. What do you think about this?

When I asked for a help back in 2025, I already have a good Numbers SS, with a lot of info, and I was dreaming with this magical touch of a graph constructed in the beginning of the month, before any data and it would be seen automatically while I was adding the data — and it would be done for each subsequent months:

If this is not possible, I am really grateful for all the time and effort that you, Ian, posted here to help me;

Meanwhile, 2 days from now, I will try to construct the graph using a great deal of your suggestions, but if now you know that it is not possible to do this graph in just 1 take, I will appreciate your advice.

Before trying, I do not know if I can send you the real SS through this forum.

So, with my best regards, “Thank You So Much”,

Jorge Lucas

an,

More extra info, before a big “Thank You”:

Jorge Lucas is not my full name: it has a “de” and the ‘Family Surname”;

There are no such a formula between the last reading of the BP and the time to take a drug (in the case I take it);

I did not click ‘yet’ in the ‘Helpful’ Button because I was waiting for that first solution of December 2025 — in the form that I was dreaming for, i.e., that it was constructed   directly in just 1 graph, with each ‘x value’ (reduced to the ‘Day(B)’) having 3 ‘y values’ (Systolic Pressure, Diastolic Pressure, Heat Rate) but the ‘magic bullet’ may not even exist because you sent 2 or 3 new solutions where you got 2 graphs overlaid;

The reason I kept dreaming with this magic solution is because I am a (retired) Math High School teacher, and in a graph of a function, the points (x,y) are calculated in a way that for each ‘x value’ there is only 1 ‘y value’ and in each of your 2-overlaid-graph solutions, the graph for the BP had, already, 2 ‘y values’ for each ‘x value’, and so, I thought, if Numbers permits this, it can permit that a ‘x value’ have 3 ‘y values’ (the magic solution);

I already recognised that “I replied to a message in the wrong place”  — and that turned the communication between us very confused, because out of order; and because of some things you said, I believe that you did not see some of the things I wrote. So, I will repost them:

              And, because I am a runner, my bpm (at rest) is low -- which means that the part related to the heart rate will not mix with the blood pressures. And, although the unit of the BP are different of the unit of the HR, there are no reasons to have different reference numbers in the graph, because the ‘HR’ number will be below the ‘Diastolic Pressure’, that is already below the ’Systolic Pressure’; but if you build 2 graphs separately, and mixed then later, an ‘HR value’ of 55, for example, can be of the same size of a ‘Systolic Pressure value’ of 150. I know that you set the ranges for each of those ‘y values’, but all of this lose the interesting magical thing of a Math graph: the ability to “see the solution”, at a glance;

              You suggested me to move the column related with the drug; instead, I changed that column to a pop up menu with 4 options: 'Medições:','Nenhuma droga', '1/2 comp. Benicar HCT 20 mg + 12.5 mg' and '1 comp. Benicar HCT 20 mg + 12.5 mg'; I also chose the size of 8 pt and I added a rule -- that should turn the text red when it contains the word "comp."; I filled the entire column and it appeared that it was everything right.

But problems occurred: just to check if what I did was working, I selected all the inputs I did from the 3rd row to the last (before the footer row) and "Clear All" them; then I tried to insert some data again, but the pop up menu was gone; the file quitted several times (signalling that something was wrongly done).

So, I spent hours doing those things and they did not work.

Maybe I should use these 4 options of the pop up menu “without using a pop up menu”: in the beginning of each month, I can list the four in that column and each time I need one, I copy it and paste it. What do you think about this?

When I asked for a help back in 2025, I already have a good Numbers SS, with a lot of info, and I was dreaming with this magical touch of a graph constructed in the beginning of the month, before any data and it would be seen automatically while I was adding the data — and it would be done for each subsequent months: If this is not possible, I am really grateful for all the time and effort that you, Ian, posted here to help me;

Meanwhile, 2 days from now, I will try to construct the graph using a great deal of your suggestions, but if now you know that it is not possible to do this graph in just 1 take, I will appreciate your advice.

Before trying, I do not know if I can send you the real SS through this forum.

So, with my best regards, “Thank You So Much”

Jorge Lucas

P.S.: I posted this before the last screenshot of November 3rd, but it disappeared.

Hi Jorge,

Jorge Lucas wrote: I was waiting for that first solution of December 2025 — in the form that I was dreaming for, i.e., that it was constructed   directly in just 1 graph, with each ‘x value’ (reduced to the ‘Day(B)’) having 3 ‘y values’ (Systolic Pressure, Diastolic Pressure, Heart Rate)

You posted this on Oct 30, 2026 9:04 PM in response to Yellowbox (Australian time!). Here is my reply to you on Dec 6,2025 5:56 AM (Australian time!)

Yes, all dates and times in this forum are our own local time (when we are logged in).

That is very interesting, but I can't remember how I did it.

Please post a link to that discussion and maybe that will jog my memory.

Regards,

Ian.

No worries, Jorge,

From your screen shot of my reply in December 2025, I was able reconstruct this graph.

It is a 2D 2-Axis graph.

The data table has one Header Row and two Header columns.

Perhaps we are getting nearer to a solution?

Regards,

Ian.

Ian,

Yeah, …, “Perhaps, Perhaps, Perhaps” like Doris Day (and others before her) would say.

This is what I am looking for and wrote about extensively — although I can not know if you noticed my writings, because this thread is out of order, and I asked your opinion about some things and did not get answers.

In November I posted a long text — that disappeared, I posted it again and the first reappeared.

It started with “Ian (the ‘I’ disappeared), … some space, … More extra info, before a big “Thank You”

I also made a change — based on a suggestion from you —, got something wrong, posted another screenshot, asked your opinion, and the order may impede you to know this text and screenshot were there.

Probably the main reason why this is not done is because of this broken mail — which was my fault by posting some messages in the wrong places.

please look for the November posts and screenshot.

Anyway, now you replicated your original post. Probably tomorrow I will be able to try to replicate that.

Do you think I must move the 2nd row — with the max values — to the footer note?

I am wishing for a “No”, because it is better where it is, but …

So, any further explanation apart the ones you already said will be appreciated.

Thanks,

Jorge Lucas (the guy from Rio Grande do Sul)

Ian,

I am posting this message here because it was your last, and when I asked you why that text size changed it was not for correcting it: it was the curiosity to know why it changed by itself.

I did just a few Numbers’ charts before, but with this series of posts I already have done a lot of graphs.

I made some changes in my SS, copied the result and played with them in order to construct that solution you did in December 2005 — and was able to reconstruct it now —, but I could not replicate it.

But now, some things you showed me are clear: (1) that column ‘Ações/Actions’ need to move in a way that the final action of the day — swallow the drug/do not swallow the drug —, should be putted in the same row of the last measures of the BP and HR, in order to eliminate the gaps of the graph. I just need to decide where to put that column, but only for the design, not the function; (2) since I was not able to replicate that graph with one ‘x value’ with 3 correspondent ‘y values’, I am now considering your other approach: do one graph for the BP, with the Systolic Pressure and Diastolic Pressure, and another graph for the Heart Rate and then mixing them in one graph. Like I said before, I am a runner and my HR is low, and, … if the two graphs have the same high … the line of the HR will not affect the lines of the BP. For this, I will have to play a little with graphs and discover if I can change the height of the graph, i.e., if my HR seldomly surpasses a given “n”, can I put the limit of ‘Y value’ of my graph to something like “3 n”? In other words, I do not want to have the final mixed graphs with 2 different scales (one for the BP and one for the HR).

This approach you did for “Mr Nobody”, and if I learn how to play with that, I will be having the magic of a Math graph, that consists in “visualising the results at a glance”, because if the ‘Maxim’ numbers in the SS shows “165” (Systolic), “97” (Diastolic) and “63” (BPM), they do not tell me how many real bad numbers I had. Instead, that graphic of “Mr Nobody”, will, at a glance, showed me if that “165” was an isolated or more common occurrence.

So, this is to thank you, again, for all the time and effort you spent helping me.

Best regards,

Jorge Lucas (the guy from Rio Grande do Sul)

Ian,

The best result I got -- and wrote about yesterday --, I posted several times around midnight (in Brasil), but it did not go. The initial 2 or 3 graphs were posted with no trouble.

Now, I will try to post it again, maybe if only the chart (without the SS) -- before reading your reply.

I slept only 4 hours and I did not even prepare my breakfast.

I will read your post later, probably in the afternoon or night, but I already thank you for that.

I really want to show it to you.

Jorge Lucas (the guy from Rio Grande do Sul)

Ian,

Before my breakfast, I must say that, finally, I could send you the SS and the best 2D- Line graph I got yesterday.

In that, you will see the SS for the entire month and your questions answered, i.e., (1) the 'Ação/Action' is what I would do next. Initially, I would collect the data and depending on that, take or not take the drug. Because of the gaps in the graph, I changed that to the last column, with only 2 options, depending on the readings of "Systolic", "Diastolic" and the "HR", I would take the drug (1/2 tablet or 1 full tablet) or I would not take it. This corresponds exactly to the name you gave to that column, that was "Medicine". It became a better view of what I had, cleaner, and I thank you for that; (2) yes, I need that column "Medicine"and I also have, in the last row, the 'Count if' function saying how many days of the month I did not take the drug -- "Dias sem drogas"= COUNTIF(L3:L62,"Nenhuma droga.")

"Nenhuma droga." means "No drugs."

I hope that you get this post, because this sequence is the worst ordered that I had ever in this forum, certainly by an error of mine in posting in the wrong place. Now, when we get into the bottom of the page there are 3 pages.

so, its very confused and sometimes I was in doubt if you saw what I posted.

Sorry for the extra trouble.

As a Math teacher during more that 30 years, one of my best rewards was the challenge to which I was exposed.

And you know why I am saying that.

Best regards,

Jorge Lucas (the guy from Brasil)

Hi, Ian.

Thanks for your generosity.

Is this what you want?

I tried to include the real SS, but it was not possible.

P.S. One more thing:

I don't know why the text size changed. You can select the whole column and change the font size.

Ian.

Sorry, I have to repeat. The forum is being naughty. And apologies if this is a duplicate post.

I had to guess with $A3+"45m" for column F

Select only columns A, B, C, D. to create your graph. Other columns to the right will not feature in your graph.

Please reply if you have problems.

Regards,

Ian.