| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel | |||
| how do i plot a rose diagram to show frequency of wind direction | Charts and Charting in Excel | |||
| Contour plot | Charts and Charting in Excel | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
Linear Mode
