Hi Everyone,
I have a chart that I am editing to make a new chart. The old chart has
values from 1 to 5, the new chart I want to make has values from
-1 to 5. When I change the scale on the edited chart all the labels along
the X axis stay at the 0 value and the -1 gridline is below the labels.
Can anyone help me? I am running Microsoft Graph ver. 11.6550.6568 SP2 with
Windows XP.

Thanks,
Art

You can offset the X-axis labels by double-clicking the axis. In the pop up
dialog box, select the Alignment tab. Adjust "offset" in the bottom left
corner of the box. Click OK.

Is this what you're looking for?
--
Sandy


"Art" wrote:

> Hi Everyone,
> I have a chart that I am editing to make a new chart. The old chart has
> values from 1 to 5, the new chart I want to make has values from
> -1 to 5. When I change the scale on the edited chart all the labels along
> the X axis stay at the 0 value and the -1 gridline is below the labels.
> Can anyone help me? I am running Microsoft Graph ver. 11.6550.6568 SP2 with
> Windows XP.
>
> Thanks,
> Art
>
>
>

No, what I need is to have the labels for the X axis below the -1 gridline
in a graph scaled form -1 to 5.

Thanks,
Art

"Sandy" <(E-Mail Removed)> wrote in message
news:1BD49041-52E5-492D-A327-(E-Mail Removed)...
> You can offset the X-axis labels by double-clicking the axis. In the pop
> up
> dialog box, select the Alignment tab. Adjust "offset" in the bottom left
> corner of the box. Click OK.
>
> Is this what you're looking for?
> --
> Sandy
>
>
> "Art" wrote:
>
>> Hi Everyone,
>> I have a chart that I am editing to make a new chart. The old chart has
>> values from 1 to 5, the new chart I want to make has values from
>> -1 to 5. When I change the scale on the edited chart all the labels along
>> the X axis stay at the 0 value and the -1 gridline is below the labels.
>> Can anyone help me? I am running Microsoft Graph ver. 11.6550.6568 SP2
>> with
>> Windows XP.
>>
>> Thanks,
>> Art
>>
>>
>>

In article <8cuxf.61$(E-Mail Removed)>, (E-Mail Removed)
says...
> Hi Everyone,
> I have a chart that I am editing to make a new chart. The old chart has
> values from 1 to 5, the new chart I want to make has values from
> -1 to 5. When I change the scale on the edited chart all the labels along
> the X axis stay at the 0 value and the -1 gridline is below the labels.
> Can anyone help me? I am running Microsoft Graph ver. 11.6550.6568 SP2 with
> Windows XP.
>
> Thanks,
> Art
>
>
>
Double-click the x-axis. In the resulting dialog box, in the Patterns
tab, set the 'Tick mark labels' to 'Low'.

For more on the subject, see Andy Pope's
http://www.andypope.info/tips/tip002.htm

And, Sandy's tip about using the Offset capability is something I
haven't used before. Nice to know about its.

--
Regards,

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

Thanks Tushar, that did it.
Art



"Tushar Mehta" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In article <8cuxf.61$(E-Mail Removed)>, (E-Mail Removed)
> says...
>> Hi Everyone,
>> I have a chart that I am editing to make a new chart. The old chart has
>> values from 1 to 5, the new chart I want to make has values from
>> -1 to 5. When I change the scale on the edited chart all the labels along
>> the X axis stay at the 0 value and the -1 gridline is below the labels.
>> Can anyone help me? I am running Microsoft Graph ver. 11.6550.6568 SP2
>> with
>> Windows XP.
>>
>> Thanks,
>> Art
>>
>>
>>
> Double-click the x-axis. In the resulting dialog box, in the Patterns
> tab, set the 'Tick mark labels' to 'Low'.
>
> For more on the subject, see Andy Pope's
> http://www.andypope.info/tips/tip002.htm
>
> And, Sandy's tip about using the Offset capability is something I
> haven't used before. Nice to know about its.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions

You are welcome.

--
Regards,

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

In article <b_uxf.76$(E-Mail Removed)>, (E-Mail Removed)
says...
> Thanks Tushar, that did it.
> Art
>
{snip}