Scatter chart data labels

[David F]

PROBLEM 1
We have data we want to display on a scatter chart. There are three
elements:
1) Name of customer
2) Square feet of area
3) Time used

The square feet and time used are the principal data to chart (data
series). However, we would like to also display the name of the customer
beside the dot on the chart. Can this be done?

PROBLEM 2
A linear trendline including formula display is useful for us. However,
I want to add additional lines by formula. Is there a way to do this?
For example, I might add a line where
y = 0.00078x + 12.3
Actually, it would be better for Excel to add 3 linear trendlines:
1) Midway in the 'time used' data, as it does now
2) Split halfway between the highest and mid-point for the 'time used'
3) Split halfway between the lowest and teh mid-point for the 'time
used'
Any pointers, such as where to start? Can it even be done?

Thanks,
David F.

 

[Frank Kabel]

Hi David
Problem 1:
- try one of the following add-ins to label your points:
http://j-walk.com/ss/excel/files/charttools.htm
http://www.appspro.com/utilities/Labeler.asp

Problem 2:
have a look at the following sites:
http://www.tushar-mehta.com/excel/charts/straight_lines/index.html
http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

HTH
Frank