Charts and custom style formats
Posted by Tom Turton on August 31, 2000 8:59 AM
I am trying to chart values vs. time blocks. I.e., I have a column
of time ranges: hh:mm:ss-hh:mm:ss, e.g. 16:22:31-16:37:31).
I have figured out how to modify cell format to accept this style
(Format->Style-> then I create a new style with appropriate format
as detailed above). However, when I create a chart, and format the
axis values with the same format, it gives me 00:00:00-00:00:00 for
all the values on the axis.
Any ideas? By the way, I'm using Excel 97.