Re: Scatter Graphs - Adding Labels to Pts

I'm not sure I understand. A column header is a single cell. Correct?
Does that mean that you want to use the same label for every data
point?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <041901c382bb$9ad5e470$a301280a@phx.gbl>,
ciara.gallagher@uk.pwc.com says...
> I have produced a scatter graph comparing two variables x
> versus Y.
>
> I am trying to add labels to each of the points on the
> scatter graph but instead of adding the column headers it
> keeps adding the x variable value????
>
> Does anyone know how I can ensure that the column header
> is shown instead - all help appreciated.
>
> Thanks,
>
> CiaraG
>

Hi,

Yes, what you do is click on one of the labels you don't want, then
enter the address of the cell containing the label you do want in the
formula bar. The trick is you have to include the Sheet name, even if
you're on that sheet.

E.g.

Suppose you're on Sheet1 and your desired chart label is in cell A1.
Highlight the existing data label and enter

=Sheet1!A1

in the formula bar. A bit fiddly if you have lots of data...



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Easier yet: select the label, type = (the equals key), and select the
cell with the mouse.

There are a couple useful and free Excel addins that can automatically
label data points, using labels in a worksheet range:
Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Gromit wrote:
> Hi,
>
> Yes, what you do is click on one of the labels you don't want, then
> enter the address of the cell containing the label you do want in the
> formula bar. The trick is you have to include the Sheet name, even if
> you're on that sheet.
>
> E.g.
>
> Suppose you're on Sheet1 and your desired chart label is in cell A1.
> Highlight the existing data label and enter
>
> =Sheet1!A1
>
> in the formula bar. A bit fiddly if you have lots of data...
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from http://www.ExcelForum.com/
>