MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Tom Turton on September 01, 0100 7:59 AM

Ah - thanks for the clue! It was the X-axis, and I was using
default values for min-max. I guess the Scatter plot needs
an integer or real number. Tried going to Bar chart or a normal
Line chart, and it seemed to handle it fine. Would prefer to use
the Scatter plot, but the others will do as a workaround. Thanks.

Posted by Ivan Moala on August 31, 0100 9:31 PM

Which axis and what values are you entering for
the Min & Max pt values ??