Negative numbers on X axis

I have a line chart that has 2 Y axis and the X axis has values from 1 to 60.
Is there a way to place negative numbers on the x axis. For example I need to
have the x axis start at -5. When I go to format axis and then Scale, it
won't let me start at -5. I am using Excel 2002.

Thank you in advance for any help.

Regards,

Dee

Is it possible that the Y axis is in a logarithmic scale?

"Dee" wrote:

> I have a line chart that has 2 Y axis and the X axis has values from 1 to 60.
> Is there a way to place negative numbers on the x axis. For example I need to
> have the x axis start at -5. When I go to format axis and then Scale, it
> won't let me start at -5. I am using Excel 2002.
>
> Thank you in advance for any help.
>
> Regards,
>
> Dee

Dear Barb,

I am not sure what that means. Could you explain?

Regards,

Dee

"Barb R." wrote:

> Is it possible that the Y axis is in a logarithmic scale?
>
> "Dee" wrote:
>
> > I have a line chart that has 2 Y axis and the X axis has values from 1 to 60.
> > Is there a way to place negative numbers on the x axis. For example I need to
> > have the x axis start at -5. When I go to format axis and then Scale, it
> > won't let me start at -5. I am using Excel 2002.
> >
> > Thank you in advance for any help.
> >
> > Regards,
> >
> > Dee

Dee,

Is the Chart Type set to XY (Scatter)? If you change it to that type,
you should be able to set the X-axis scale to what you need.

Also, when you are editing the X-axis scale, make sure the box next to
"Logarithmic Scale" is NOT checked. Don't worry about what it means,
you do not want that option.

Mark

"Dee" wrote:
> I have a line chart that has 2 Y axis and the X axis has values from
1 to 60.
> Is there a way to place negative numbers on the x axis. For example I
need to
> have the x axis start at -5. When I go to format axis and then Scale,
it
> won't let me start at -5. I am using Excel 2002.

> Thank you in advance for any help.

> Regards,

> Dee

I apologize. I really misread the question.

"Dee" wrote:

> Dear Barb,
>
> I am not sure what that means. Could you explain?
>
> Regards,
>
> Dee
>
> "Barb R." wrote:
>
> > Is it possible that the Y axis is in a logarithmic scale?
> >
> > "Dee" wrote:
> >
> > > I have a line chart that has 2 Y axis and the X axis has values from 1 to 60.
> > > Is there a way to place negative numbers on the x axis. For example I need to
> > > have the x axis start at -5. When I go to format axis and then Scale, it
> > > won't let me start at -5. I am using Excel 2002.
> > >
> > > Thank you in advance for any help.
> > >
> > > Regards,
> > >
> > > Dee