Length of Time in Axis Scale

  • Thread starter Thread starter David
  • Start date Start date
D

David

I've created a formula to convert a number into a length
of time in 5 min increments. Ex. 2.5 = 2.30 for 2 hrs and
30 minutes. 3.23 = 3.15 for 3 hrs and 15 min.

I've charted this data and would like the scale to follow
suit. For instance instead of going from 2.59 - 2.60, I
would like the scale to go to 3.00.

I thought I might would be able to create a custom list to
show in the scale but I've had no luck.

Can someone help?

Thanks
 
You will have to simulate this effect. But, first, a clarification.
You meant 3.25 = 3:15, ot 3.23 = 3:15. Correct?

If you have a chart other than a XY Scatter Chart, just use the
computed values (i.e., 3:15) as the x values. As long as your x data
are equidistant (5 minutes apart, for example) that is all you need.

If the data are not equidistant, you have to use a XY Scatter chart.
Now, suppose you have the decimal values for the times you want to show
on the x-axis in column F starting with F2. Also suppose you have the
corresponding clock values in column H (starting with H2). Now, in
column G, starting with G2, enter zeros in all rows that have
information in column H. Add F:G to the chart. You should have a
horizontal line along the x-axis. Use the XY Chartlabeler
(www.appspro.com) or the Chart Tools (www.j-walk.com) to add column H
as the labels for this new series.

Double click the x-axis. From the Patterns tab set the 'Tick mark
labels' to 'None.' Make other aesthetically pleasing changes as
desired.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar -

You can use the times as your X values directly in an XY Scatter chart.
Use a number format of h:mm for the axis labels, and enter the times in
h:mm format in the Format Axis - Scale dialog. Excel converts the scale
parameters to decimal fractions, but only after you enter them.

Dummy series are required to get lots of special axis effects, but this
doesn't need them.

- Jon
 
Duh! What was I thinking?

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top