XY Scatter with Custom Labels

hatzipet · #1 10-06-2005, 05:48 PM

I have a list of products, each with an X (a dollar amount) and a Y value (a percentage). Is it possible to have each point labeled with a custom value i.e.: Printer, or Digital Camera, rather than it being labeled with just the values being plotted ($1,000, 2% or $500, 7%)?

Any ideas are appreciated.

Thanks,
Keith

#2 10-07-2005, 01:05 AM

You can edit the text of a label, to manually insert your desired labels. In
addition, there are third party Excel add-ins that allow you to apply labels from a
worksheet range to a series of data points. Two good ones are:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

hatzipet wrote:

> I have a list of products, each with an X (a dollar amount) and a Y
> value (a percentage). Is it possible to have each point labeled with a
> custom value i.e.: Printer, or Digital Camera, rather than it being
> labeled with just the values being plotted ($1,000, 2% or $500, 7%)?
>
> Any ideas are appreciated.
>
> Thanks,
> Keith
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)