Need help with time scale chart

krugan

New Member
Joined
Jan 27, 2005
Messages
4
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.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

mjbeam

Well-known Member
Joined
Apr 6, 2002
Messages
756
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

New Member
Joined
Jan 27, 2005
Messages
4
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

Well-known Member
Joined
Apr 6, 2002
Messages
756
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
 

Forum statistics

Threads
1,147,508
Messages
5,741,568
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top