use a time value in a bar graph
 

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

use a time value in a bar graph
 

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.
--
David Biddulph

"pdfrone" wrote in message
...
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

use a time value in a bar graph
 

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

"David Biddulph" wrote:

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.
--
David Biddulph

use a time value in a bar graph
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"pdfrone" wrote in message
...

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

"David Biddulph" wrote:

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.
--
David Biddulph

use a time value in a bar graph
 

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

pdfr

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"pdfrone" wrote in message
...

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

"David Biddulph" wrote:

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.
--
David Biddulph