SAVE ME!! Elapsed time chart with min and max values

[ToddinTampa]

Hello everyone,

I need help creating a bar chart that shows elapsed time that has a minimum value and maximum value. We have multiple servers that run concurrently on a job daily. We want to show (in a bar chart) by day the minimum and maximum elapsed time. The Y axis would have the time in HH:MM:SS format from 00:00:00 to 06:00:00. The X axis would have the date (Jan 1, January 2, January 3 etc.). The chart itself would have a vertical bar that starts at a value greater than zero (perhaps 01:45:22, for example and would rise to the maximum value (04:54:11, for example. How can I create this?

 

[Glove_Man]

You can't really. However, you can hack your way into a very close approximation of what you want.

You need to use a stacked bar chart. Then chart two series:

(1) Minimum time.

(2) Maximum time MINUS minimum time.

Final step is to select the minimum time series, then make it the same colour as the chart background and also fully transparent. The chart then looks like what you want it to look like.

It's not perfect, and can sometimes make the gridlines disappear, but it looks the way you want it to look.

 

[ToddinTampa]

You can't really. However, you can hack your way into a very close approximation of what you want.

You need to use a stacked bar chart. Then chart two series:

(1) Minimum time.

(2) Maximum time MINUS minimum time.

Final step is to select the minimum time series, then make it the same colour as the chart background and also fully transparent. The chart then looks like what you want it to look like.

It's not perfect, and can sometimes make the gridlines disappear, but it looks the way you want it to look.

Sounds as though we are in the same mindset with the approach you suggested. I too thought about making a stacked bar chart with one of the bars and its outline in white.

Thanks!

ToddinTampa