Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / June 2006

Tip: Looking for answers? Try searching our database.

connect points on an X Y scatter chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Genevieve - 23 Jun 2006 19:06 GMT
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 - 23 Jun 2006 20:35 GMT
> 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?

Signature

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

Genevieve - 23 Jun 2006 20:50 GMT
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
[quoted text clipped - 3 lines]
> That's generally the way to add a line. But...does your datasheet for the
> scatterchart have empty data cells?
Echo S - 23 Jun 2006 23:46 GMT
Okay, thanks.

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

Signature

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:
>
[quoted text clipped - 11 lines]
> > That's generally the way to add a line. But...does your datasheet for the
> > scatterchart have empty data cells?
Genevieve - 26 Jun 2006 14:07 GMT
Yes. Thank you!!!

> Okay, thanks.
>
[quoted text clipped - 16 lines]
> > > That's generally the way to add a line. But...does your datasheet for the
> > > scatterchart have empty data cells?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.