Thanks James. Is it not possible to do this with a bar chart? I'm guessing
no. I have done it with a scatter chart. The problem is, it's not easy to
see the values of the points as with a bar chart. My boss would like to be
able to easily determine the value of the point and it's proximity to the Y
axis. With the scatter chart the proximity looks great but because of the
"scattered dots" you cannot easily discern the value of the dot...
Does that make sense?



"James Silverton" wrote:

Kell2604 wrote on Fri, 20 Feb 2009 06:06:10 -0800:

I am trying to chart some data. My X axis runs from -100 to
100. When I chart the data the graph shows all data to the
Right of the Y axis (0) and nothing to the left. So my X axis
goes 0, -100, -50, -25, 25, 50, 100 etc. How can I get
information (my negative values) to show up to the LEFT of the
Y axis or to the LEFT of the 0? The data I am working with is
below.

Thanks very much!!

Assuming a standard graph ("scatter chart"), the crossing point of what
Excel calls the "value axis" (y) can be set by right-clicking on the
x-axis values Format axisScale. You may also need to set the value
range for x.
--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not