NEWBIE - Simple graph question.

Newbie with a simple question.

I have a graph and I want the X -axis data to show up at the bottom of the
graph instead of inside the graph. The X axis are dates (Jan-Dec) and the Y
axis are performance numbers from -10% to +20% and the dates are sitting on
the 0% line which sits right on the graph.

I have attatched the actual xls file attached.

Thanks for your help.

Phil

Try:

Right-click on the X-axis and select "Format Axis" and in" Tick mark
labels" select "Low"

--
HTH

Sandy
[email protected]
[email protected] with @tiscali.co.uk


"Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
news:[email protected]...
> Newbie with a simple question.
>
> I have a graph and I want the X -axis data to show up at the bottom of the
> graph instead of inside the graph. The X axis are dates (Jan-Dec) and the
> Y axis are performance numbers from -10% to +20% and the dates are sitting
> on the 0% line which sits right on the graph.
>
> I have attatched the actual xls file attached.
>
> Thanks for your help.
>
> Phil
>
>

Thanks Sandy, but that didn't work

BUT you did give me the location on where I was able to get it to work. I
didn't know about the Format Axis option. Under there I found in the SCALE
tabe, you can set the the X axis crosses at (x) and that fixed my problem.

Thanks!

Phil


"Sandy Mann" <[email protected]> wrote in message
news:OL$q1%[email protected]...
> Try:
>
> Right-click on the X-axis and select "Format Axis" and in" Tick mark
> labels" select "Low"
>
> --
> HTH
>
> Sandy
> [email protected]
> [email protected] with @tiscali.co.uk
>
>
> "Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
> news:[email protected]...
>> Newbie with a simple question.
>>
>> I have a graph and I want the X -axis data to show up at the bottom of
>> the graph instead of inside the graph. The X axis are dates (Jan-Dec)
>> and the Y axis are performance numbers from -10% to +20% and the dates
>> are sitting on the 0% line which sits right on the graph.
>>
>> I have attatched the actual xls file attached.
>>
>> Thanks for your help.
>>
>> Phil
>>
>>
>
>

Perhaps it is only in XL 97 but the important thing is that you got it to
work yourself.

--
Regards

Sandy
[email protected]
[email protected] with @tiscali.co.uk

"Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
news:[email protected]...
> Thanks Sandy, but that didn't work
>
> BUT you did give me the location on where I was able to get it to work. I
> didn't know about the Format Axis option. Under there I found in the
> SCALE tabe, you can set the the X axis crosses at (x) and that fixed my
> problem.
>
> Thanks!
>
> Phil
>
>
> "Sandy Mann" <[email protected]> wrote in message
> news:OL$q1%[email protected]...
>> Try:
>>
>> Right-click on the X-axis and select "Format Axis" and in" Tick mark
>> labels" select "Low"
>>
>> --
>> HTH
>>
>> Sandy
>> [email protected]
>> [email protected] with @tiscali.co.uk
>>
>>
>> "Phillip Vong" <phillip_vong*at*yahoo*dot*com> wrote in message
>> news:[email protected]...
>>> Newbie with a simple question.
>>>
>>> I have a graph and I want the X -axis data to show up at the bottom of
>>> the graph instead of inside the graph. The X axis are dates (Jan-Dec)
>>> and the Y axis are performance numbers from -10% to +20% and the dates
>>> are sitting on the 0% line which sits right on the graph.
>>>
>>> I have attatched the actual xls file attached.
>>>
>>> Thanks for your help.
>>>
>>> Phil
>>>
>>>
>>
>>
>
>