Excel data labels from other data

D

DIOS

I have plotted some data on a chart and it looks great. However I want
to put a data label on each point that is part of another row like so:

Date 3/12/03 5/20/03
Bldgheight 25 26
BldgName HDQ1 HDQ2

The graph is made up of date on the x-axis and height on the y-axis.
However when the points are displayed I want the data label to display
the Name row. is that possible.

AGP
 
D

DIOS

Well since this Excel sheet has to be viewed by many I decided to do
it through some VBA code. Works quite well with this line:

xlChartMain.SeriesCollection("My Series").Points(j).DataLabel.Text =
sBName

where j is a specific numbered point that seems to start at 1 from the
first point all the way up to number of the last point. Note that if
data is skipped on the data sheet then that number is also skipped.
Instead of j you could also use the name of the point. I just generate
an example and hover over the point and the info will appear as a
tooltip.

AGP
 
Top