PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting labeling data points on a scatter chart

Reply

labeling data points on a scatter chart

 
Thread Tools Rate Thread
Old 31-03-2006, 12:31 PM   #1
=?Utf-8?B?TXIgVGVl?=
Guest
 
Posts: n/a
Default labeling data points on a scatter chart


Hey guys.

I need some help with my scatter diagram im using for a marketing
assignment, about cars.

So i have thee collums, the 1st is the car type e.g. "Mustang" and the 2nd
is the torque e.g. "300" and lastly then the Price e.g. "20 000"

What i want, is for each data point on the scatter chart to have the cars
name next to it.

Using the the e.g. data/figures above, i would have at the point (300, 20
000) the word "mustang" next to it.

Help: How do i do this?

Thanx guys!!!
  Reply With Quote
Old 31-03-2006, 01:15 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: labeling data points on a scatter chart

After plotting the X and Y values, you can use a third party labeling
utility. Here are two free Excel add-ins that will do the trick:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

Both are easy to install and use, and work seamlessly within Excel's user
interface.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Mr Tee" <Mr Tee@discussions.microsoft.com> wrote in message
news:F44BA3C8-DD58-4E25-AFF1-5C0C94501E4F@microsoft.com...
> Hey guys.
>
> I need some help with my scatter diagram im using for a marketing
> assignment, about cars.
>
> So i have thee collums, the 1st is the car type e.g. "Mustang" and the 2nd
> is the torque e.g. "300" and lastly then the Price e.g. "20 000"
>
> What i want, is for each data point on the scatter chart to have the cars
> name next to it.
>
> Using the the e.g. data/figures above, i would have at the point (300, 20
> 000) the word "mustang" next to it.
>
> Help: How do i do this?
>
> Thanx guys!!!



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off