Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 11th 05, 05:39 PM
shabnam
 
Posts: n/a
Default scatter plot & label for a data point

I wrote this question several days ago, but was not able to get a solution to
the problem. Apologies for repeating it, but I am still hopeful that someone
knows how to do this. It seems like an important aspect of using charts, and
Excel *certainly* must have a way of dealing with this.

I have three columns of data as follows:
Name Value1 Value2
a 1 2
b 3 4
c 5 6

when i do a scatter plot, i can move the cursor to a specific item - let's
say for "b" above - and it shows ("3" 3,4). What I need is for it to show
("b" 3,4). I know that you can have all labels explicitly shown on the
chart, but i have over a thousand data points and doing that would make the
chart useless. I need to be able to find the label of some data points
though, and would like to use the cursor to see the name for that data point.
There must be a way to do this, but i have been looking and using "help" to
no avail.

Please help, and i will be eternally grateful.
-shabnam


  #2   Report Post  
Old April 11th 05, 06:04 PM
Barb R.
 
Posts: n/a
Default

It appears that you data for your series is in rows rather than columns.
Please confirm. In any case, if the name for series 1 is located on Sheet 1,
Cell A3, you'd enter =Sheet1!$A$3

Good luck!

"shabnam" wrote:

I wrote this question several days ago, but was not able to get a solution to
the problem. Apologies for repeating it, but I am still hopeful that someone
knows how to do this. It seems like an important aspect of using charts, and
Excel *certainly* must have a way of dealing with this.

I have three columns of data as follows:
Name Value1 Value2
a 1 2
b 3 4
c 5 6

when i do a scatter plot, i can move the cursor to a specific item - let's
say for "b" above - and it shows ("3" 3,4). What I need is for it to show
("b" 3,4). I know that you can have all labels explicitly shown on the
chart, but i have over a thousand data points and doing that would make the
chart useless. I need to be able to find the label of some data points
though, and would like to use the cursor to see the name for that data point.
There must be a way to do this, but i have been looking and using "help" to
no avail.

Please help, and i will be eternally grateful.
-shabnam

  #3   Report Post  
Old April 11th 05, 06:34 PM
shabnam
 
Posts: n/a
Default

Y

"Barb R." wrote:

It appears that you data for your series is in rows rather than columns.
Please confirm. In any case, if the name for series 1 is located on Sheet 1,
Cell A3, you'd enter =Sheet1!$A$3

Good luck!

"shabnam" wrote:

I wrote this question several days ago, but was not able to get a solution to
the problem. Apologies for repeating it, but I am still hopeful that someone
knows how to do this. It seems like an important aspect of using charts, and
Excel *certainly* must have a way of dealing with this.

I have three columns of data as follows:
Name Value1 Value2
a 1 2
b 3 4
c 5 6

when i do a scatter plot, i can move the cursor to a specific item - let's
say for "b" above - and it shows ("3" 3,4). What I need is for it to show
("b" 3,4). I know that you can have all labels explicitly shown on the
chart, but i have over a thousand data points and doing that would make the
chart useless. I need to be able to find the label of some data points
though, and would like to use the cursor to see the name for that data point.
There must be a way to do this, but i have been looking and using "help" to
no avail.

Please help, and i will be eternally grateful.
-shabnam

  #4   Report Post  
Old April 11th 05, 06:37 PM
shabnam
 
Posts: n/a
Default

Yes, the data is in rows, meaning that point "a" has 1 for x value and 2 for
y value. The "name" for the series does not work because it does not assign
a "label" with the corresponding point, but lists ALL names under Series 1
which is a bizarre.

Here is what i need to know. If i find a data point in the plot that i want
to examine, i need to know what its label is.

thanks.
-shabnam

"Barb R." wrote:

It appears that you data for your series is in rows rather than columns.
Please confirm. In any case, if the name for series 1 is located on Sheet 1,
Cell A3, you'd enter =Sheet1!$A$3

Good luck!

"shabnam" wrote:

I wrote this question several days ago, but was not able to get a solution to
the problem. Apologies for repeating it, but I am still hopeful that someone
knows how to do this. It seems like an important aspect of using charts, and
Excel *certainly* must have a way of dealing with this.

I have three columns of data as follows:
Name Value1 Value2
a 1 2
b 3 4
c 5 6

when i do a scatter plot, i can move the cursor to a specific item - let's
say for "b" above - and it shows ("3" 3,4). What I need is for it to show
("b" 3,4). I know that you can have all labels explicitly shown on the
chart, but i have over a thousand data points and doing that would make the
chart useless. I need to be able to find the label of some data points
though, and would like to use the cursor to see the name for that data point.
There must be a way to do this, but i have been looking and using "help" to
no avail.

Please help, and i will be eternally grateful.
-shabnam



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
Adding more source data to existing scatter plot Tom Charts and Charting in Excel 1 March 21st 05 11:03 PM
how to add data points to a scatter plot with trend line Samantha Charts and Charting in Excel 2 February 28th 05 01:54 PM
Scatter Graph - Data Label Problems TBD Charts and Charting in Excel 2 January 16th 05 06:08 PM
creating names for data shown on a scatter plot budski Charts and Charting in Excel 1 December 22nd 04 06:15 PM
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 2 November 29th 04 09:22 PM


All times are GMT +1. The time now is 12:20 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017