chart point labels ? 1

[rb1957]

i've got a chart with a bunch of data points on it.

when i hover over a point i get the point's values.

each point has a label (a separate loadcase designator).

can i get excel to tell me the label rather than the point values ?

thx

 

[electricpete]

Hmm. Excel 2003, in an x-y plot, right-click on the series and select "Format data series". Select tab "Data Labels".

The choices are:
show values (shows y values)
show label (shows x values)

Unless I'm misunderstanding, it's very easy to do what you want.

=====================================
(2B)+(2B)' ?

 

[rb1957]

thx, but sorry, you did misunderstand ...

i know i can easily get the co-ordinates (the x- and y- values, labels, whatever) of a point on a chart.

for each of the data plotted there is also a loadcase "label" (in a column on the same sheet). i know i can find the point (and then the loadcase), but it'd be nice if excel could tell me the loadcase description rather than the co-ordinates ...

 

[IDS]

When I point at a point in an x-y chart in Excel 2010 the first thing it gives is the Series name, then the x value, then the x and y value.

Do you not get that, or is that not what you want?

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[rb1957]

yes that's what i get.

i'd like to get the loadcase "label" that's associated with the point.

ie i have ... loadcse Fx Fz
110204 10000 -2000

if i click the chart excel will tell me "10000, -2000". i'd like it to say "100204"

 

[StephenA]

Rather long winded but if you add each point as a separate series you could call the series the loadcase. Of course you could not join the dots thereafter.

Otherwise in Excel 2007 you can only have x, y and / or series that I can see.

Stephen Argles
Land & Marine

http://www.landandmarine.com

 

[Drew08]

Below is a short bit of VBA code that accomplishes adding different labels. This assumes the new labels are listed in column A and starts at row A1, which can be changed. Also, assumes your adding labels to series 1, which also can be changed. Select on the chart in question and run the code.

It's not eloquent but it gets the job done.

Sub ADD_LABELS()

Dim NewLabel As Double
Dim Row As Integer
Dim Col As String
Dim Count As Integer
Dim SeriesNum As Integer

Count = 5 'set to number of points
Row = 1 'set to starting row
Col = "A" 'set to starting column
SeriesNum = 1 'set to series Number

ActiveChart.SeriesCollection(SeriesNum).ApplyDataLabels
For n = 1 To Count
NewLabel = Range(Col & Row)
ActiveChart.SeriesCollection(SeriesNum).Points.DataLabel.Text = NewLabel
Row = Row + 1
Next n

End Sub

 

[rb1957]

thx Drew, i'll give it a try

 

[IRstuff]

I still don't understand. If your curves are correctly formatted with the curve title as the 1st element of the 4 in SERIES, the hover tip will show name of the curve. The only reason it wouldn't is if you didn't include the curve's name in the SERIES command. Even then it should at least say "Series X" where X is the 4th of the 4 parameters SERIES.

TTFN
faq731-376

 

[IDS]

I think rb1957 wants a separate label for each point, based on the contents of a selected spreadsheet range, rather than the series name.

If that is the case, this is a free utility that will do it:

http://www.appspro.com/Utilities/ChartLabeler.htm

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[rb1957]

yes, IDS ... rather than the series name, or the point co-ordinates, i'd like a point specific label (ie i have a column of labels, one for each point).

i'll try your utility first ... then the VBA script !?

 

[GregLocock]

google is your friend

http://support.microsoft.com/kb/213750

for example

Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376

http://eng-tips.com/market.cfm?