negative number scatter plot

A

Armyuser

I am trying to plot some data I have in a scatter plot. It contains several
values that are positive and negative, but all of the negative values apprear
as zero on the plot. I have tried changing the numbers to scientific and
changing the plot area but to no avail. I am using Excel 2007, but this is
something I did regularly in Excel 2003 with no issue.
 
B

Bernard Liengme

And it is no issue in Excel 2007.
Try remaking the chart; your negative values should display correctly.
I wonder if the problem chart has the Scale range set to Min of 0

If it fails, please post some sample data. Feel free to email me personally
(address is on website)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Mixing scatter plot with a category plot 2
Fill Positive and Negative Areas under a Scatter Plot Different Co 12
Scatter plot 1
Display Negative Time Values on Y-Axis 0
Excel 2007: Lines not displayed on Scatter Plot 0
Bubble Chart best fit Scatter plot 3
X-Axis Appearing in Plot Area 2

Top