Need help with time scale chart

[krugan]

Is there a way in Excel to do the same kind of Time Demand Chart as the one in the link below?

http://home.cogeco.ca/~krugan

I can't find a way on the 'x' axis to show the width in seconds for the flow rate and the amount of time in total during the cycle.

 

[mjbeam]

There is probably an addin chart that you can buy somewhere that can do that.

You could also do it with some code. If you wrote some code that broke out your data into one second intervals (ie. 8,8,8,8,8,8 instead of 8gpm for 6 seconds) and you changed the distance between the bars in a bar graph to zero, you could create a graph that looks like that one.

-Mike

 

[krugan]

Addin, as in a third party program that can be used with excel or different program altogether?

I guess if I have to purchase something like that I'll just do it in autoCAD. I'm suprised no MS programs can do something like that.

 

[mjbeam]

Addin as a new chart type that you would probably have to purchase.

You can do it, you just have to write a little code.


-Mike