I always use scatter plots to visualize my data and after I upgraded to Excel
2007, something weird started to happen. What I do to is to Insert --
Scatter -- "Scatter with only markers", then I get a blank chart. Now I
select the chart and type in "Series(, x range, y rang, 1)" and hit enter,
now it gives me a chart with both markers and lines, so I have to go back to
Insert -- scatter -- "Scatter with only markers" again and get rid of the
connecting line. I'd love to hear suggestions on how to fix this, this is
really annoying.

I don't know why you started with a blank chart. Had you selected the data
first? Excel detects the active cell and the range around it, and plots the
data it suspects you want.

You can select the chart and press Ctrl+1 (numeral one) to format the
series. Go to the marker tab and select a marker, then go to the line tab
and remove the line. It's not nearly as easy as it was in Excel 2003.

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


"wigner" wrote in message
...
I always use scatter plots to visualize my data and after I upgraded to
Excel
2007, something weird started to happen. What I do to is to Insert --
Scatter -- "Scatter with only markers", then I get a blank chart. Now I
select the chart and type in "Series(, x range, y rang, 1)" and hit enter,
now it gives me a chart with both markers and lines, so I have to go back
to
Insert -- scatter -- "Scatter with only markers" again and get rid of
the
connecting line. I'd love to hear suggestions on how to fix this, this is
really annoying.

Thanks Jon.
The way I do plotting is what I've been doing for years, can't remember from
whom I learned it.
But anyway, the Ctrl+1 does make getting rid of the annoying line faster.
But still, since I choose to plot the "Scatter with only markers", why can't
it just give me a clean marker only plot, instead it gives me a "Scatter with
markers and straight line"? And making the "makers only" plot the default
won't help either: whenever I go back to the scatter chart menu the icon with
"Scatter with markers and straightlines" is always highlighted.
Thanks again.

"Jon Peltier" wrote:

I don't know why you started with a blank chart. Had you selected the data
first? Excel detects the active cell and the range around it, and plots the
data it suspects you want.

You can select the chart and press Ctrl+1 (numeral one) to format the
series. Go to the marker tab and select a marker, then go to the line tab
and remove the line. It's not nearly as easy as it was in Excel 2003.

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


"wigner" wrote in message
...
I always use scatter plots to visualize my data and after I upgraded to
Excel
2007, something weird started to happen. What I do to is to Insert --
Scatter -- "Scatter with only markers", then I get a blank chart. Now I
select the chart and type in "Series(, x range, y rang, 1)" and hit enter,
now it gives me a chart with both markers and lines, so I have to go back
to
Insert -- scatter -- "Scatter with only markers" again and get rid of
the
connecting line. I'd love to hear suggestions on how to fix this, this is
really annoying.