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
|
|||
|
|||
X Y Charts - Different Label for Each Point
I have a similar issue to the one posted in "Why does X axis become another
data series". I want to build an X Y chart with a different label for each of the rows/points. For example, Item Distance Height Red 0 5 Blue 5 4 Green 8 3 When I do an X Y Chart on this data, it gives me a point for Distance and a second point for Height for eash "Item" (let's say a square is used as the point marker on the chart for "Red", in this case I get two squares). I just want 1 point at the intersection of Distance/Height, with the point format changed for each row (square for Red, triangle for Blue, diamond for Green, for example). Thank you. |
#2
|
|||
|
|||
X Y Charts - Different Label for Each Point
If you don't want to format each point separately, your best bet is to put
each point in as a separate series. I don't think that the wizard will do this easily for you, so you'll need to add them a series at a time. -- David Biddulph "D. Wilkerson" D. wrote in message ... I have a similar issue to the one posted in "Why does X axis become another data series". I want to build an X Y chart with a different label for each of the rows/points. For example, Item Distance Height Red 0 5 Blue 5 4 Green 8 3 When I do an X Y Chart on this data, it gives me a point for Distance and a second point for Height for eash "Item" (let's say a square is used as the point marker on the chart for "Red", in this case I get two squares). I just want 1 point at the intersection of Distance/Height, with the point format changed for each row (square for Red, triangle for Blue, diamond for Green, for example). Thank you. |
#3
|
|||
|
|||
X Y Charts - Different Label for Each Point
Excel 2007
Change each point marker name, style, size, color and outline with macro. http://c0444202.cdn.cloudfiles.racks...10_31_09a.xlsm |
#4
|
|||
|
|||
X Y Charts - Different Label for Each Point
Plot the points as a single series, using Distance and Weight values.
Format the series to "Vary colors by point". In 2003 it's on the Options tab of the Format Series dialog. In 2007 I don't know where it is, because I hadn't yet thought of varying colors by point while using 2007. Then use Rob Bovey's Chart Labeler add-in to apply the labels in the Item column to the points. It's free at http://appspro.com. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ D. Wilkerson wrote: I have a similar issue to the one posted in "Why does X axis become another data series". I want to build an X Y chart with a different label for each of the rows/points. For example, Item Distance Height Red 0 5 Blue 5 4 Green 8 3 When I do an X Y Chart on this data, it gives me a point for Distance and a second point for Height for eash "Item" (let's say a square is used as the point marker on the chart for "Red", in this case I get two squares). I just want 1 point at the intersection of Distance/Height, with the point format changed for each row (square for Red, triangle for Blue, diamond for Green, for example). Thank you. |
Thread Tools | |
Display Modes | |
|
|