Hi again - thanks for your detailed message. So, basically, if I understand
correctly, because my data is "scaleable", such as cel/far temperature, it
isn't possible to have markers that correspond on the two axis. The only way
to reflect the value for a certain amount is to add the labels as per your
instructions.

Just want to make sure I'm totally clear on this. Thanks!!

--
Thanks!

Dee


"Del Cotter" wrote:

On Thu, 30 Aug 2007, in microsoft.public.excel.charting,
dee said:
I can arrange the data in any way, so that isn't a problem. Del mentioned
adding labels manually, which wouldn't be a problem, as I don't have many
items to chart. I'm not sure how to do this, though.

If you create some labels with one of the automatic options Excel
provides (value or category), you can then select the label series by
single-clicking on one of the labels. If you then carefully single-click
again on a label (not too fast; you don't want to double-click), a
single label out of the whole range is selected.

Now if you go up to the formula bar above the chart and spreadsheet, and
type in an equals sign followed by a cell reference, or type an equals
sign and then navigate to the cell you want that label to refer to, the
label will display the contents of that cell.

(if you find you've accidentally created a text box, that means you
hadn't selected one label: the text box will correctly display the cell
value, but won't move around properly to follow the series marker when
you change the graph)

Repeat for each label, and you've now got customized data labels that
can display anything, instead of only the value or category of the
series marker. Excel should long ago have included an option to select a
cell range to create all the labels at once (Lotus 123 had this back in
the 1980s!), but fortunately there are little add-ins distributed free
by friendly Excel experts if you have a heavy load of such labels.
Whether you want to do it manually or install one of the add-ins depends
on how much of this kind of thing you expect to do.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.