Question 1. Are you sure you're making a SCATTER chart? It's the fifth
option in the Chart Type panel of the Chart Wizard. Line charts are the
third option, and they are NOT what you want. Read this article for
more information:
http://pubs.logicalexpressions.com/P...cle.asp?ID=190
Question 2. There are a couple of free addins that use worksheet cells
for data labels, instead of just the X or Y labels.
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
M B wrote:
Thanks John, however, the chart output does not yield the desired
effect.
I can not get my range of data to appear as (column a, column b)
coordinate points, i.e., (sales, margin). I have to plot them one at a
time using series selecting each x and y point. It does not plot them
(x,y) when I select a range.
Also, is it possible to show the data points with the item name as a
data label rather than the value?
Thanks...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!