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
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 ?
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 ?
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 ?
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 ?
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 ?
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 ?
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 ?
RE: chart point labels ?
TTFN

FAQ731-376: Eng-Tips.com Forum Policies
RE: chart point labels ?
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/
RE: chart point labels ?
i'll try your utility first ... then the VBA script !?
RE: chart point labels ?
http://support.microsoft.com/kb/213750
for example
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?