Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David F. Schrader
 
Posts: n/a
Default Labels on Chart with Negative Value Axis

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


  #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




  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

If you don't know what the minimum Y value is going to be, set it to some
ridiculously low value, like -1000000000, so it's always less than the actual Y axis
minimum.

On a log scale you can't use negative numbers, so instead you'd use a ridiculously
small number, 0.0000000001

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

Barb Reinhardt wrote:

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






  #4   Report Post  
David F. Schrader
 
Posts: n/a
Default

Thank you Jon.

That's an idea. The values are all integers but negative but I
have no easy way to play with the "raw data" to change
impose an "absolute" on it. I hadn't thought of using a
"log" scale on the chart. I try it and see what happens.

Thanks.

David

"Jon Peltier" wrote in message
...
If you don't know what the minimum Y value is going to be, set it to some
ridiculously low value, like -1000000000, so it's always less than the

actual Y axis
minimum.

On a log scale you can't use negative numbers, so instead you'd use a

ridiculously
small number, 0.0000000001

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

Barb Reinhardt wrote:

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








  #5   Report Post  
David F. Schrader
 
Posts: n/a
Default

Barb,

I'm talking about the information pulled from the
actual data which is used for labels on the X (or
Y) axis. For example, the month of the year - 1
through 12.

I'm a bit at a loss as to how to "scale" the values
as you suggest. My minimum will always by 0
while the maximum can range into the negative
hundreds or thousands.

Any suggestions
"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






  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default

David -

A log scale will not accept negative numbers or zeros. Just pick a very negative number.

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

David F. Schrader wrote:

Thank you Jon.

That's an idea. The values are all integers but negative but I
have no easy way to play with the "raw data" to change
impose an "absolute" on it. I hadn't thought of using a
"log" scale on the chart. I try it and see what happens.

Thanks.

David

"Jon Peltier" wrote in message
...

If you don't know what the minimum Y value is going to be, set it to some
ridiculously low value, like -1000000000, so it's always less than the


actual Y axis

minimum.

On a log scale you can't use negative numbers, so instead you'd use a


ridiculously

small number, 0.0000000001

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

Barb Reinhardt wrote:


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








  #7   Report Post  
David F. Schrader
 
Posts: n/a
Default

The most negative number I can imagine is
-0.

<big ugly smirk

Which I suspect would *really* give Excel
fits.

David

"Jon Peltier" wrote in message
...
David -

A log scale will not accept negative numbers or zeros. Just pick a very

negative number.

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

David F. Schrader wrote:

Thank you Jon.

That's an idea. The values are all integers but negative but I
have no easy way to play with the "raw data" to change
impose an "absolute" on it. I hadn't thought of using a
"log" scale on the chart. I try it and see what happens.

Thanks.

David

"Jon Peltier" wrote in message
...

If you don't know what the minimum Y value is going to be, set it to

some
ridiculously low value, like -1000000000, so it's always less than the


actual Y axis

minimum.

On a log scale you can't use negative numbers, so instead you'd use a


ridiculously

small number, 0.0000000001

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

Barb Reinhardt wrote:


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










Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating an x,y coordinate chart smintey Charts and Charting in Excel 2 December 9th 04 05:01 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Linking Axis Labels Neil Charts and Charting in Excel 2 December 5th 04 10:04 PM
Scatter chart x axis tick mark lables so Charts and Charting in Excel 2 December 2nd 04 06:06 AM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 07:44 PM


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"