Discontinuous X axis

I am trying to plot a series of data that has values at 1 hour, 2 hours, 4
hours, and 24 hours. Is there a way to plot it so that the data for the
first four hours isn't squished against the right side?

Hi,

If you are not worry about the spacing between points being a true
representation of the distance then change the axis type to Category
instead of Time series. Right click the chart and choose Chart Options
from the popup menu. On the Axis tab change the axis type.

Cheers
Andy

genscientist wrote:
> I am trying to plot a series of data that has values at 1 hour, 2 hours, 4
> hours, and 24 hours. Is there a way to plot it so that the data for the
> first four hours isn't squished against the right side?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks for the advice Andy. Worked great!
:-)

"Andy Pope" wrote:

> Hi,
>
> If you are not worry about the spacing between points being a true
> representation of the distance then change the axis type to Category
> instead of Time series. Right click the chart and choose Chart Options
> from the popup menu. On the Axis tab change the axis type.
>
> Cheers
> Andy
>
> genscientist wrote:
> > I am trying to plot a series of data that has values at 1 hour, 2 hours, 4
> > hours, and 24 hours. Is there a way to plot it so that the data for the
> > first four hours isn't squished against the right side?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

Hi Andy -

In general, the time scale doesn't recognize times, only integral numbers of
days. In other words, it's a date-scale axis. But if it's a line chart
anyway, it could still behave as you suggest.

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


"Andy Pope" <andy@andypope.info> wrote in message
news:%238sglxk%23FHA.1716@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> If you are not worry about the spacing between points being a true
> representation of the distance then change the axis type to Category
> instead of Time series. Right click the chart and choose Chart Options
> from the popup menu. On the Axis tab change the axis type.
>
> Cheers
> Andy
>
> genscientist wrote:
>> I am trying to plot a series of data that has values at 1 hour, 2 hours,
>> 4 hours, and 24 hours. Is there a way to plot it so that the data for
>> the first four hours isn't squished against the right side?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info