How to plot Z value instead of a dot in a xy-diagram
 

Point X Y Z
1 11 3 4,5
2 15 7 4,23
3 17 8 4,25
4 19 9 4,75
5 22 11 4,22

showing it as a xy-coordinates with Z as a text to dot
or just showing measure point in diagram

Have done it before but was it in Excel!!

How to plot Z value instead of a dot in a xy-diagram
 

Plot X and Y, then use one of these free utilities to add the Z column to
the chart as data labels. Center the labels on the points. You can then
format the points so they do not appear (no line, no markers).

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

Both tools are free, and integrate with Excel.

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


"xYeti" wrote in message
...
Point X Y Z
1 11 3 4,5
2 15 7 4,23
3 17 8 4,25
4 19 9 4,75
5 22 11 4,22

showing it as a xy-coordinates with Z as a text to dot
or just showing measure point in diagram

Have done it before but was it in Excel!!

How to plot Z value instead of a dot in a xy-diagram
 

Tnx
I had a feeling that I did it with a VB-macro
%)

silly that i didn't save it..



"Jon Peltier" skrev:

Plot X and Y, then use one of these free utilities to add the Z column to
the chart as data labels. Center the labels on the points. You can then
format the points so they do not appear (no line, no markers).

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

Both tools are free, and integrate with Excel.

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


"xYeti" wrote in message
...
Point X Y Z
1 11 3 4,5
2 15 7 4,23
3 17 8 4,25
4 19 9 4,75
5 22 11 4,22

showing it as a xy-coordinates with Z as a text to dot
or just showing measure point in diagram

Have done it before but was it in Excel!!