Charts with negative values

[Art]

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

 

[Sandy]

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?

 

[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

 

[Tushar Mehta]

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

 

[Art]

Thanks Tushar, that did it.
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

 

[Tushar Mehta]

You are welcome.

--
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

{snip}