use a time value in a bar graph

[Guest]

i have values in a series

like

c5 9:01
d5 21:01
e5 =(d5-c5)

I would like to use e5 in a bar graph it gives values which would make sense
only to excel

 

[David Biddulph]

If the axis is formatted as time, it shouldn't be a problem. If it doesn't
choose the scales to give clean divisions, you can choose an appropriate
unit on the axis, such as 03:00.

 

[Guest]

thanks do you know how to set the scale in vba or vb.net

 

[Jon Peltier]

Turn on the macro recorder while you adjust the scale manually to get an
inefficient version of the VBA code.

- Jon

 

[Guest]

thanks a lot problem solved. Went through the related link on your site and
got the required code.

pdfr