blood pressure chart help please :)

Still using Excel 2010??

OK. So first thing, please update your profile.


Then...

more explanation is needed. N3 can contain what ??? Nothing or a date?? If N3 contains nothing, what do you want to see? Ig N3 contains a date, what do you want to see.

As more data are added, is N3 going to keep moving to the right?

Your data layout is .... not great. Also I can't read Hebrew. Is בוקר someone's name, or what?

How much flexibility is there regarding layout?

Please answer ALL questions from Posts 4 to 6.

Have a look at this. No graphs yet... but how does this look as an alternative layout (you STILL have not answered ANY of my Questions).

What do you mean by "attach my table from the previous issue". The original data are still there (in another sheet). I just mocked up data in a more Excel-friendly way (in columns, not rows).

Give me a chance... I didn't want to do that until I knew you were OK with a revised layout.

Something like this???

The filtered data are off to the right hand side

Is it possible to make spaces in the chart like I have?
>> Probably, but I'm not very good with Excel charts. I suggest that once everything else is done, you ask a new Q.


And also how do I make the dates displayed in the table be displayed upside down and not according to 6 days back? For example, I write 10/9 which will be a subsequent date.

>> I have absolutely no idea what you are asking here!!

That the table be reversed?
Date of the beginning of a week that will appear first in the table

For the last time... S...H...O...W me. The earliest date DOES come first

There is NO POINT in repeating the same words in a different order. Actually SHOW me what you want.

The bit you are pointing to is the raw data, where you add new values (at the bottom) each day. The actual data used to populate the chart is in columns T to Z...

So, I still have no idea what you expect to see, as you were pointing in the wrong area. This is a blind guess...

My mistake in the picture
I mean this table
that the date I write in J2 will be the first in the table

https://prnt.sc/fr4v_2xSKYes

Like this??

(I hope this isn't affecting your blood pressure!!).

You are being imprecise.

You enter 10 Sep... and 5 days. It shows 10-14 Sep (5 days).

Which day should appear at the TOP of the filtered list?

Which day should appear at the LEFT of the graph?

Two Qs. Two answers, please.

Let's say I write down the date 10/9 which will continue to appear on the dates 11/9, 12/9. 13/9. 14/9, 15/9

You are a champion

https://prnt.sc/cn85OSDO-43r

Hopefully this is it.

I'm a bit odd, maybe, as I am MUCH better at picking things up when I SEE what people want, rather than READING what people want. I'm not dyslexic (I think) as I had to read masses of stuff for work each and every day. Maybe, being a scientist I have very exacting expectations when it comes to a written specification.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Then change the number of days to be displayed in J1 to WHATEVER you want. the chart will adjust from 1 day to ALL days included in the data, depending on your selection.

All you need to do to finish this is to change the bit here, in red, to something sensible and future-proof... 100, 500, 1000 or whatever.


=LET(A,A3:G20,B,FILTER(A,(INDEX(A,,1)<>"")),SORT(IF(OR(I1="",I2=""),B,TAKE(FILTER(B,INDEX(B,,1)<=I2),I1)),1,-1))

.Once again I have NO IDEA what you are asking for

Open your pictures from Post 27 and 34. They are BOTH what you say you want. They are DIFFERENT.

Make your mind up, and post a FINAL description of what you want. We are going in circles because YOU are not being clear, YOU are NOT answering my Qs and YOU are changing your mind.

The next one will be my LAST go... so make 110% sure it's what you want.

1. In the sample file I added, the raw data stop at 15/9. There are therefore no data to return beyond the 15th.

2. J1 asks for 7 days data, in the raw data there are only 6 available days worth of data (as data for 16/9 have not been added). Therefore only 6 results are returned.

3. According to the pic in Post 34, the earliest date sould appear first in the Table. It does.

4. Despite being asked MANY times to explain what you want, you have ONCE AGAIN, NOT stated which date should appear first in the chart. So, it currently shows the earliest date at the left.

5. And yes, I am getting soooo close to walking away from this thread. That's the beauty of the EF. I do this for fun. If I think someone is messing me around, I simply walk away. When I do that, I do NOT return.

Phew! Relief. My blood pressure subsides to normal.

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

You didn't tell me what you want!!!

Is it (in D3)...

TEXT((TODAY()+1)-WEEKDAY(TODAY(),1),"dd/mm/yyyy")-7

I can't read your mind...

Try the following in cell D3:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.