Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dennis
 
Posts: n/a
Default xy scatter with third value labels?

I need to create an xy scatter graph with a third data value (temperature)
labeling each point (label can be either text or graphical).

Seems like this should be possible, even easy, but my extensive attempts
have all failed. Does anyone know how to do this?

I am actually doing this in an Access form but I believe the solution in
Excel should be applicable.

Thanks alot,
Dennis

  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

DO you mean a 3-axis BY chart?
Not really possible but Jon Peltier has a possible workaround
http://www.peltiertech.com/Excel/Charts/index.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dennis" wrote in message
...
I need to create an xy scatter graph with a third data value (temperature)
labeling each point (label can be either text or graphical).

Seems like this should be possible, even easy, but my extensive attempts
have all failed. Does anyone know how to do this?

I am actually doing this in an Access form but I believe the solution in
Excel should be applicable.

Thanks alot,
Dennis



  #3   Report Post  
Dennis
 
Posts: n/a
Default

My data has 3 columns, first two columns are the x and y values that I want
plotted, the third column is a value that I want to label the xy point with.
x,y,T
13.5, 14.5, 25
I want the point x=13.5, y=14.5 plotted on the graph and for it to have a
label of "25".
There are five xy points and each will have a unique T value label: the
first point always has a T-value of 25, the second 45, the third 65, the 4th
85, the fifth 105.

Thanks,



"Bernard Liengme" wrote:

DO you mean a 3-axis BY chart?
Not really possible but Jon Peltier has a possible workaround
http://www.peltiertech.com/Excel/Charts/index.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dennis" wrote in message
...
I need to create an xy scatter graph with a third data value (temperature)
labeling each point (label can be either text or graphical).

Seems like this should be possible, even easy, but my extensive attempts
have all failed. Does anyone know how to do this?

I am actually doing this in an Access form but I believe the solution in
Excel should be applicable.

Thanks alot,
Dennis




  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

You can use one of these helpful Excel add-ins to apply labels from a third range to
your data points. Both are easy to install and use.

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

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

Dennis wrote:

My data has 3 columns, first two columns are the x and y values that I want
plotted, the third column is a value that I want to label the xy point with.
x,y,T
13.5, 14.5, 25
I want the point x=13.5, y=14.5 plotted on the graph and for it to have a
label of "25".
There are five xy points and each will have a unique T value label: the
first point always has a T-value of 25, the second 45, the third 65, the 4th
85, the fifth 105.

Thanks,



"Bernard Liengme" wrote:


DO you mean a 3-axis BY chart?
Not really possible but Jon Peltier has a possible workaround
http://www.peltiertech.com/Excel/Charts/index.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dennis" wrote in message
...

I need to create an xy scatter graph with a third data value (temperature)
labeling each point (label can be either text or graphical).

Seems like this should be possible, even easy, but my extensive attempts
have all failed. Does anyone know how to do this?

I am actually doing this in an Access form but I believe the solution in
Excel should be applicable.

Thanks alot,
Dennis





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
data labels in xy scatter kbpratt Charts and Charting in Excel 9 March 20th 07 06:47 PM
Labels for Scatter Diagrams ksn Charts and Charting in Excel 1 July 2nd 05 03:46 PM
How to assign datalabels to a scatter chart, obtaining the labels. Jos Koot Excel Discussion (Misc queries) 1 April 22nd 05 12:11 PM
Moving labels in a scatter plot Ian Belcher Charts and Charting in Excel 1 March 30th 05 10:24 PM
How do I add column A data labels to a scatter of columns B and C? Christina1 Charts and Charting in Excel 3 March 27th 05 03:43 AM


All times are GMT +1. The time now is 01:33 PM.

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"