negative number scatter plot
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. |
negative number scatter plot
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Armyuser" wrote in message ... 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. |
All times are GMT +1. The time now is 06:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com