Splitting Stacked Columns in Numbers

Question

Level 1

8 points

Splitting Stacked Columns in Numbers

I have a data set in Numbers with 4 values per day. I want to stack the first two data values, then stack the third and fourth values as a second stacked column for that day.

Im tracking blood pressure, taking Systolic and Diastolic in the morning and evening. To get the candlestick look, I'm stacking the range between systolic and diastolic on top of diastolic, then setting the diastolic opacity to zero.

In the chart below, what I WANT to do is have a range column for the AM Range+AM Dias next to the current range column.

MacBook Pro

Posted on Aug 5, 2022 6:44 AM

Reply

Answer 1

Badunit

Level 7

31,142 points

Aug 6, 2022 6:20 PM in response to curly in ptc

Thee is no chart that does multiple stacked columns for each X axis point. You can create two stacked column charts (one with the first two series and one with the other two) and, with some work adjusting them, overlay one on the other but I don't know how to get the X axis labels to be centered unless a third chart is made that is just for the labels.

Reply

Answer 2

SGIII

Level 8

37,654 points

Aug 5, 2022 7:41 AM in response to curly in ptc

Could you post a screenshot of your table and chart?

shift-command-4, select area with cross-hairs, release, start new post here and insert the screenshot image from the Desktop using the mountains-and-moon icon beneath the compose window.

SG

Reply

Answer 3

Barry

Level 9

60,064 points

Aug 6, 2022 4:53 PM in response to curly in ptc

I tried that in the original post. For some reason it's telling me "You have included content in your post that is not permitted."

You may have included the name of a person on the chart. Try again, with any 'real' names changed to anonymous 'names' like Sample one, Sample 2, etc.

You might even change the charted quantity names.

REgards,

Barry

Reply