Bar Chart..plot median bar with graph

[exceliz]

Hi...any chance of this working?...

i have a graph showing a count of patients by how many weeks they have waited
But i need to show what the median wait would be...

I have all this in figures but is it possible to show the median as one of the bars.

i.e. all the bars from weeks 01 - 40 weeks are blue, but the 20th week is showing red to highlight the median?? is this dooable?

Thanks v much
Liz x

 

[GlennUK]

Have you non-median values as one series ( with a 0 where the median is ), and a series of zeros with a single non-zero value for the median, and plot as a stacked bar ... the series will be different colours.

 

[exceliz]

Im not sure i understand?

and also how would i lookup up the median (which is in a cell calcualted already)
and plot it against each weeks wait? i couldnt do a lookup to bring back 0 for each weeks until it met the median because of the amount of If's needed. my median can range from 0 to 18 weeks

Thanks

sorry to be a pain

and on another note... i will be doing the 95th %ile too which can range to 35 weeks

 

[GlennUK]

Can you show your data, and show the cell formula that calculates the median? I should be able to do an example of what I mean, if I have that.

 

[exceliz]

thanks v much

how would i show, its a bit of a knightmare in a speadsheet - could i send it?

 

[GlennUK]

I've sent you a PM.