Scatter charts with 2 variables and labels

[edeaston]

Hi,

I need to create a scatter chart in PowerPoint which has 2 variables and
labels to represent the seperate teams and I am not sure how to do it.

Effectively I need to get the following data into a chart
x (planned time) y (actual time) Team name
100 150
abc
150 128
def
175 250
ghi
250 250
jkl

where the planned time is shown on the x axis, actual time on the y and then
display labels to see the team name. I know I could create seperate columns
for each team but that seems ineffecient and wont be easy with the potential
number of teams I have.

Thanks in advance for your help

Ed

 

[Andy Pope]

Hi,

There is no easy way to assign text to data labels in powerpoint if you are
using MSGraph.
Using a column for each team and staggering the Y values is the simplest
approach.

I have posted some code on how to load data labels with text, if you are
really interested.
http://www.andypope.info/ngs/ng16.htm

Cheers
Andy

 

[edeaston]

Hi Andy,

I would be interested in hearing more about this macro to create the labels.
I have looked at the link below and found the ppt file with the macro in but
it didnt work when I tried to run in my presentation - I am using Office 2003
but it seemed to have problems with the code. Any ideas?

Thanks

Ed

 

[Andy Pope]

Hi,

Did you try running it in the example file.
You will need to add extra information to the data sheet

If you still have problems email me off newsgroup with details for failure.

andy AT andypope DOT info

Cheers
Andy