connect points on an X Y scatter chart

[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.

 

[Echo S]

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?

 

[Guest]

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.

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

 

[Guest]

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

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.

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

 

[Guest]

Yes. Thank you!!!

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

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.

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

 

[bobjones]

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.