negative values on axes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi there;
this is my first mail here. well my x axes start from -2 and my Y axes data
start from -5, I change both to -5 (scale) they are shown (XY scatter dots)
as cross, like + sign. what I need:
how to change the graph punt the joint axes point from 0 to -5? so the
chart shws as usual not like a cross.
Best
Darius
 
Hi,

Change the Values axis crosses at to -5 for both axis.
This is an option on the Scale tab of the Format Axis dialog.

Cheers
Andy
 
Here's a trick I use to avoid having to readjust the Crosses At parameter whenever
the data changes. I enter a ridiculously low value, like -1000000. On a log scale, I
use something like 0.0000001.

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