Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default 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.



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
Fill Positive and Negative Areas under a Scatter Plot Different Co [email protected] Charts and Charting in Excel 3 March 4th 09 03:49 PM
xy scatter plot Andrew Excel Discussion (Misc queries) 2 November 4th 08 07:28 PM
XY scatter plot JayK Charts and Charting in Excel 3 March 11th 08 12:37 PM
scatter plot Jules Excel Worksheet Functions 2 January 17th 08 07:43 PM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM


All times are GMT +1. The time now is 02:44 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"