View Single Post
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

Are you talking about data labels or the labels on the X axis. Try
formatting the X axis scale and changing the the "Value (Y) axis Crosses
at:" value. If it were me, I'd probably set it to the minimum Y value.

"David F. Schrader" wrote in message
...
I have a question about an Excel chart. I have a series of graphs which
compare a number of factors relating to "card swipe" data. This relates
to data plotting on an X (horizontal) and Y (vertical) axis graph. The
X axis represents the month of the year. The Y axis is the "data error
rate." Data is stored for each successful and each unsuccessful
"swipe." Successful swipes are positive valued while unsuccessful
are negative. In some cases all of the values are negative.

When these values are plotted Excel inverts the graph the graph and
places the labels into the body of the graph. Since the values are
all negative the graph is plotted completely below the "X" axis.
Of course, Excel also places the labels in the same place it over
writes the chart.

I found a way to "move" the label up and down "below" the axis but
Excel still thinks that the axis is above the "X" axis rather than below
it. (And it can't be moved down enough to make it worth while.)

Anyone have any easy/quick ideas that don't require modifying all of my
data or creating a new set of cells with the "absolute" values?

David Schrader