×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

chart point labels ?

chart point labels ?

chart point labels ?

(OP)
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

RE: chart point labels ?

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)'  ?

RE: chart point labels ?

(OP)
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 ...  

RE: chart point labels ?

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/
 

RE: chart point labels ?

(OP)
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"

RE: chart point labels ?

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
www.landandmarine.com

RE: chart point labels ?

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(n).DataLabel.Text = NewLabel
    Row = Row + 1
Next n

End Sub

RE: chart point labels ?

(OP)
thx Drew, i'll give it a try

RE: chart point labels ?

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: Eng-Tips.com Forum Policies

RE: chart point labels ?

(OP)
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 !?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources