Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to label last point for selected series only | Excel Discussion (Misc queries) | |||
how do I put a text label on a point in an XY scatter | Charts and Charting in Excel | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
How do I add a unique data label to each point in a bubble chart? | Charts and Charting in Excel | |||
scatter plot & label for a data point | Charts and Charting in Excel |