use a time value in a bar graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Turn on the macro recorder while you adjust the scale manually to get an
inefficient version of the VBA code.

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

pdfr
 
Back
Top