Charting time? help please...
 

I have trouble charting time values formatted as [mm]:ss specifically when
the values are 0 as in "0:00" when that happens, it makes all my other values
the same relative height (I am charting using a standard bar graph) so
different values are all charted as if the had the same value! I have tried
different things but can figure it out, I have not found any books on
charting either.
If anyone can help, I would greatly appreciate it.
G.M.

Gustavo -

Are the times X values or Y values? Could you include a broader sample of your data?

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

Gustavo Monteverde wrote:

I have trouble charting time values formatted as [mm]:ss specifically when
the values are 0 as in "0:00" when that happens, it makes all my other values
the same relative height (I am charting using a standard bar graph) so
different values are all charted as if the had the same value! I have tried
different things but can figure it out, I have not found any books on
charting either.
If anyone can help, I would greatly appreciate it.
G.M.