Excel: using data labels as markers


V

Velson Horie

I want to show the distribution of properties of products across two axes.
Excel 2003 sp3, on Win XP sp2

How do I place the code numbers of the products at the coordinates, i.e.
using text in a cell as the marker for each point? I used to be able to do
this easily in Quattro, but cannot see a way in Excel.

The following Help instructions do not work:
"Reestablish links between data labels and worksheet cells
Click a chart sheet or an embedded chart to display the Chart menu.
On the Chart menu, click Chart Options.
On the Data Labels tab, select the Automatic text check box. "
because there is no automatic text check box

Thank you
 
Ad

Advertisements

V

Velson Horie

Thank you, this is a considerable improvement on Excel, but does not achieve
what is required. I want to replace the marker by the text, not have it in
addition. The only way I can do it using the Addin is by setting the marker
to "none", then moving the label down by 9 points to sit over the position
where the marker was. Then when I change the shape of the chart, everything
goes out of position.

Is there a method of telling Excel to use the text as marker instead of the
pre-defined marker graphic?

Velson
 
A

Andy Pope

Why not set the label position to Center? This will place it directly over
the point.

Cheers
Andy
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top