Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 09, 01:13 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 5
Default Excel: using data labels as markers

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

  #2   Report Post  
Old April 27th 09, 02:22 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Excel: using data labels as markers

Hi,

You can use a free addin to make the link between data labels and cell text
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Velson Horie" wrote in message
...
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


  #3   Report Post  
Old April 27th 09, 03:35 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 5
Default Excel: using data labels as markers

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

"Andy Pope" wrote:

Hi,

You can use a free addin to make the link between data labels and cell text
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Velson Horie" wrote in message
...
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



  #4   Report Post  
Old April 27th 09, 03:44 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Excel: using data labels as markers

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Velson Horie" wrote in message
...
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

"Andy Pope" wrote:

Hi,

You can use a free addin to make the link between data labels and cell
text
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Velson Horie" wrote in message
...
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




  #5   Report Post  
Old April 27th 09, 09:49 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 5
Default Excel: using data labels as markers

How sensible! And it keeps position during rescalling.
Thank you

Velson

"Andy Pope" wrote:

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Velson Horie" wrote in message
...
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

"Andy Pope" wrote:

Hi,

You can use a free addin to make the link between data labels and cell
text
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Velson Horie" wrote in message
...
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Data Markers, Limit Qty Jeko Charts and Charting in Excel 4 May 10th 09 09:50 AM
Data Markers ivy_gayle Charts and Charting in Excel 1 January 3rd 07 08:36 AM
Excel Data Markers, Limit Qty Jeko Charts and Charting in Excel 3 December 1st 06 03:43 AM
Excel should allow correlations of data so chart markers match up TLC Charts and Charting in Excel 1 August 11th 06 03:03 PM
Change all data markers (excel chart) to triangles in one command jawn Charts and Charting in Excel 1 November 26th 05 06:07 PM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017