Labels for X-Y (Scatter) Chart

[Guest]

Is it possible to have labels generated for an X-Y (scatter) chart? I know
that in Excel it can be done with add-ins -- what about PowerPoint?

Thanks

 

[Echo S]

Is it possible to have labels generated for an X-Y (scatter) chart? I know
that in Excel it can be done with add-ins -- what about PowerPoint?

PPT doesn't have this feature, either. You're best off doing the chart in
Excel and using the add-ins there to generate the XY labels.

 

[Guest]

Do you mean copy-paste an Excel chart into PowerPoint?

I hate doing that because of the erratic way in which the two programs
interact...

Henrik

 

[Echo S]

Yes, copy/paste is usually the way to get the chart into Excel, although
Edit/Paste Special gives you more options and may be better in some
situations.

What is it you're finding erratic? Maybe there's a way we can overcome that.

 

[Marcus Analyst]

Henrik, can you please explain how you would add labels in an Excel xy
scatter with an add-in? I have never used add-ins before?

Also, is it possible to have several data series in an xy PPT scatter?
(Basically, I want to have one set of points one color/marker type, and
another set as a different color/marker type.

Any help would be appreciated.

 

[Echo S]

Here's the XY Chart Labeler for Excel:
http://www.appspro.com/Utilities/ChartLabeler.htm

Yes, you can have several data series in a scatter chart in PPT. Just put
the data in the appropriate row. To see an example, insert a new chart,
which should default to a column chart with 3 data series. Right-click and
choose Chart Type. Select the XY Scatter type. When you hit OK, the chart
will change to a scatter chart with East, West and North data series.

Additionally, sometimes my data looks like this for a scatter chart:

2 4 5 2 4 6 2 4 8
series A
series B
series C


Ah, man, that's hard to do here. See screenshot here:
http://screencast.com/t/5giCFm0AB

Basically, repeat your axis values on the top row as necessary. I find that
that lets me keep my data together when the axis values aren't exactly the
same.

 

[Marcus Analyst]

Thanks! I'm going to try this now.
--
Marc

Here's the XY Chart Labeler for Excel:
http://www.appspro.com/Utilities/ChartLabeler.htm

Yes, you can have several data series in a scatter chart in PPT. Just put
the data in the appropriate row. To see an example, insert a new chart,
which should default to a column chart with 3 data series. Right-click and
choose Chart Type. Select the XY Scatter type. When you hit OK, the chart
will change to a scatter chart with East, West and North data series.

Additionally, sometimes my data looks like this for a scatter chart:

2 4 5 2 4 6 2 4 8
series A
series B
series C


Ah, man, that's hard to do here. See screenshot here:
http://screencast.com/t/5giCFm0AB

Basically, repeat your axis values on the top row as necessary. I find that
that lets me keep my data together when the axis values aren't exactly the
same.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

 

[Marcus Analyst]

It worked - thank you very much Echo!
--
Marc

Here's the XY Chart Labeler for Excel:
http://www.appspro.com/Utilities/ChartLabeler.htm

Yes, you can have several data series in a scatter chart in PPT. Just put
the data in the appropriate row. To see an example, insert a new chart,
which should default to a column chart with 3 data series. Right-click and
choose Chart Type. Select the XY Scatter type. When you hit OK, the chart
will change to a scatter chart with East, West and North data series.

Additionally, sometimes my data looks like this for a scatter chart:

2 4 5 2 4 6 2 4 8
series A
series B
series C


Ah, man, that's hard to do here. See screenshot here:
http://screencast.com/t/5giCFm0AB

Basically, repeat your axis values on the top row as necessary. I find that
that lets me keep my data together when the axis values aren't exactly the
same.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx