Length of Time in Axis Scale

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

In article ,
says...
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

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tushar Mehta wrote:

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.

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

In article ,
says...
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tushar Mehta wrote:

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.