If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Line Charts with 3 sets of data?
I have a table with 3 columns. 2 of the columns include
the X and Y values for the plot (results should be one line plotted on the graph.) I want the 3rd column values to act as corresponding labels to the plots. Example: x y A 1 4 B 2 3 C 3 2 D 4 1 So (1,4) is one point, (2,4), etc. I need the (1,4) point to be labeled as A. Is it possible? Any help is appreciated!! |
#2
|
|||
|
|||
Line Charts with 3 sets of data?
Hi Jo -
There are a couple of free add-ins that can handle labeling of data points: Rob Bovey's Chart Labeler (http://appspro.com) John Walkenbach's Chart Tools (http://j-walk.com) - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ J. Stacey wrote: I have a table with 3 columns. 2 of the columns include the X and Y values for the plot (results should be one line plotted on the graph.) I want the 3rd column values to act as corresponding labels to the plots. Example: x y A 1 4 B 2 3 C 3 2 D 4 1 So (1,4) is one point, (2,4), etc. I need the (1,4) point to be labeled as A. Is it possible? Any help is appreciated!! |
#3
|
|||
|
|||
Line Charts with 3 sets of data?
J. Stacey wrote:
I have a table with 3 columns. 2 of the columns include the X and Y values for the plot (results should be one line plotted on the graph.) I want the 3rd column values to act as corresponding labels to the plots. Example: x y A 1 4 B 2 3 C 3 2 D 4 1 So (1,4) is one point, (2,4), etc. I need the (1,4) point to be labeled as A. Is it possible? Any help is appreciated!! Jon Peltier wrote: There are a couple of free add-ins that can handle labeling of data points: Rob Bovey's Chart Labeler (http://appspro.com) John Walkenbach's Chart Tools (http://j-walk.com) Jon's reply showed up before the original post, so I'll have to add to Jon's comments. J. Stacey, you want an XY scatter chart instead of a line chart. Put the X and Y data in the "X values" and "Y values" slots. Then use Jon's suggestions to label those data points with A, B, C, D.... Dave dvt at psu dot edu |
#4
|
|||
|
|||
Line Charts with 3 sets of data?
thanks!
-----Original Message----- Hi Jo - There are a couple of free add-ins that can handle labeling of data points: Rob Bovey's Chart Labeler (http://appspro.com) John Walkenbach's Chart Tools (http://j-walk.com) - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ J. Stacey wrote: I have a table with 3 columns. 2 of the columns include the X and Y values for the plot (results should be one line plotted on the graph.) I want the 3rd column values to act as corresponding labels to the plots. Example: x y A 1 4 B 2 3 C 3 2 D 4 1 So (1,4) is one point, (2,4), etc. I need the (1,4) point to be labeled as A. Is it possible? Any help is appreciated!! . |
Thread Tools | |
Display Modes | |
|
|