connect points on an X Y scatter chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have a line connecting points on a scatter chart? I can go
into "format data series" and add a line, but it does not show up on the
chart.
 
Genevieve said:
Is it possible to have a line connecting points on a scatter chart? I can
go
into "format data series" and add a line, but it does not show up on the
chart.
Click to expand...

That's generally the way to add a line. But...does your datasheet for the
scatterchart have empty data cells?
 
The data looks like this:

<a href="http://photobucket.com" target="_blank"><img
src="http://i24.photobucket.com/albums/c30/gennygogo/data.jpg" border="0"
alt="Photobucket - Video and Image Hosting"></a>

I would keep the points in each country connected by a line.

Echo S said:
Genevieve said:
Is it possible to have a line connecting points on a scatter chart? I can
go
into "format data series" and add a line, but it does not show up on the
chart.
Click to expand...

That's generally the way to add a line. But...does your datasheet for the
scatterchart have empty data cells?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com
Click to expand...
 
Okay, thanks.

Open the chart and go to Tools|Options, and on the Chart tab, click
"interpolated." That should do it.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! San Diego, September 17-20 http://www.pptlive.com


Genevieve said:
The data looks like this:

<a href="http://photobucket.com" target="_blank"><img
src="http://i24.photobucket.com/albums/c30/gennygogo/data.jpg" border="0"
alt="Photobucket - Video and Image Hosting"></a>

I would keep the points in each country connected by a line.

Echo S said:
Genevieve said:
Is it possible to have a line connecting points on a scatter chart? I can
go
into "format data series" and add a line, but it does not show up on the
chart.
Click to expand...

That's generally the way to add a line. But...does your datasheet for the
scatterchart have empty data cells?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com
Click to expand...
Click to expand...
 
Yes. Thank you!!!


Echo S said:
Okay, thanks.

Open the chart and go to Tools|Options, and on the Chart tab, click
"interpolated." That should do it.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! San Diego, September 17-20 http://www.pptlive.com


Genevieve said:
The data looks like this:

<a href="http://photobucket.com" target="_blank"><img
src="http://i24.photobucket.com/albums/c30/gennygogo/data.jpg" border="0"
alt="Photobucket - Video and Image Hosting"></a>

I would keep the points in each country connected by a line.

Echo S said:
Is it possible to have a line connecting points on a scatter chart? I can
go
into "format data series" and add a line, but it does not show up on the
chart.

That's generally the way to add a line. But...does your datasheet for the
scatterchart have empty data cells?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com
Click to expand...
Click to expand...
Click to expand...
 
I'm reviving a zombie thread here to ask: how do you do this in PowerPoint 2010? I want interpolated lines in X-Y scatter plots with some blank cells in the data array, but it looks like these instructions no longer apply. Any help would be appreciated.
 
Back
Top