blood pressure chart help please :)

[maorphp]

Hello everyone, I am trying to create a chart in Excel that every day will show the results (as in the picture) and that the columns will be contiguous. I would appreciate your help


The date is only displayed once in the table

[popipipo]

https://www.vertex42.com/Files/downl...ure-chart.xlsx
Look here for an example

[maorphp]

Thank you but, Is it possible to make 6 columns appear, 3 of each result, on the same date?

[sandy666]

try to be more creative with your description

[maorphp]

There were 6 columns for that day sys, dia
This means there were 3 tests every day

[sandy666]

like this?

bloodchart.png

[maorphp]

Thanks for the help But no, is it possible to summarize 6 columns for the date 17.6.23 (only 1 date each time).

[maorphp]

I made a sample on paper

[sandy666]

create example excel file with generic source and manually created expected result

[sandy666]

maybe this but as I said in post above

bloodchart.png

or

bloodchart.png

or

bloodchart.png

[maorphp]

I made an example file
But there are 3 same dates (17.6.23) How do I leave one date with the 3 results of that day?

[sandy666]

choose one from post#10

[maorphp]

I succeeded, but how do I bring the columns that are on the same date close to each other?

That every result will be close in columns?

Thanks

[maorphp]

Final result:
But how do I make profits between tests on the same day?

[sandy666]

see this one

[maorphp]

between each result
sys-dia space sys-dia space sys-dia

pic: https://prnt.sc/_PMeLLOt8sop

How do I do it for all dates?

[sandy666]

probably you'll need to add columns with 0 height and defined non-zero width

look at this maybe it will help: Excel Charts: Tips, Tricks and Techniques

try with Select Data / Hidden and Empty cells - choose the best optiob for you

[maorphp]

I managed to put spaces
Can you help me, why can't I see the dates below?

Thanks for all the help

[sandy666]

re-create chart from scratch
(don't use merged cells)

[maorphp]

Yes that's what I did
Thanks
This is the result

[sandy666]

see this one

[sandy666]

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful) (if you did it - ignore this)

and then mark the thread as SOLVED (top above your first post - Thread Tools)

[josephteh]

Following up on the good work of Sandy, here are some suggestions:
1) Plot the data on rows rather than columns, as new data will continue to be added
2) Put the data in Excel's structured table format so the data source range can expand automatically when new data are added
3) Add in additional columns like "Month" and maybe also "Day of Week" to better filter the chart
4) Add in also Max SYS and Max DIA line to momitoring those readings above the limits
5) I have also added Conditional Formatting to highlight those readings abve the max values

[maorphp]

Very nice!!!
Thanks to everyone

[popipipo]

I think a line graph is clearer than a bar graph

[sandy666]

You are welcome