LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to label last point for selected series only EricBB Excel Discussion (Misc queries) 1 January 22nd 09 10:56 AM
how do I put a text label on a point in an XY scatter Paul Charts and Charting in Excel 1 October 4th 08 01:54 PM
How to rezize data label box in pie charts (label wraps to two lin rolliedogg Charts and Charting in Excel 1 October 18th 06 08:17 PM
How do I add a unique data label to each point in a bubble chart? Bryan Charts and Charting in Excel 1 May 20th 06 01:29 AM
scatter plot & label for a data point shabnam Charts and Charting in Excel 3 April 11th 05 06:37 PM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"