Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 215
Default Numbering Data Points on Chart

Hello;

I've few data series plotted on XY Scatter Chart.
Each data series consists of numerous data points numbered 1, 2, 3, ... in a
column on the w/s to the left of X values.
Let us assume:
Series 1
point # :: A2:A20
X Values:: B2:B20
Y Values:: C2:C20

Is there a practical way to display the point # beside the point marker on
the 2D chart for all points and for all series ??
(For obviously reasons, one can't treat each point as a series and display
series name).

Your help would be greatly appreciated.
Thank you.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Numbering Data Points on Chart

Create the points using columns B and C, then use one of these free
utilities to apply the labels from column A to the plotted points:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"monir" wrote in message
...
Hello;

I've few data series plotted on XY Scatter Chart.
Each data series consists of numerous data points numbered 1, 2, 3, ... in
a
column on the w/s to the left of X values.
Let us assume:
Series 1
point # :: A2:A20
X Values:: B2:B20
Y Values:: C2:C20

Is there a practical way to display the point # beside the point marker on
the 2D chart for all points and for all series ??
(For obviously reasons, one can't treat each point as a series and display
series name).

Your help would be greatly appreciated.
Thank you.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 215
Default Numbering Data Points on Chart

Hi Jon;

Will access the two sites you kindly provided.

Regards.


"Jon Peltier" wrote:

Create the points using columns B and C, then use one of these free
utilities to apply the labels from column A to the plotted points:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"monir" wrote in message
...
Hello;

I've few data series plotted on XY Scatter Chart.
Each data series consists of numerous data points numbered 1, 2, 3, ... in
a
column on the w/s to the left of X values.
Let us assume:
Series 1
point # :: A2:A20
X Values:: B2:B20
Y Values:: C2:C20

Is there a practical way to display the point # beside the point marker on
the 2D chart for all points and for all series ??
(For obviously reasons, one can't treat each point as a series and display
series name).

Your help would be greatly appreciated.
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
Best Method to Chart Numerous Data Points [email protected] Charts and Charting in Excel 1 December 16th 07 01:13 PM
Excel chart data points FranLew Excel Discussion (Misc queries) 8 September 24th 07 02:18 PM
Data Points in Chart Mike Excel Discussion (Misc queries) 4 February 23rd 07 01:20 PM
Embedding pictures on data points of a chart [email protected] Charts and Charting in Excel 1 February 16th 06 06:30 PM
Data Points in Scatter Chart CWILSON Charts and Charting in Excel 2 January 25th 05 04:41 PM


All times are GMT +1. The time now is 05:46 AM.

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

About Us

"It's about Microsoft Excel"