Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2006

Tip: Looking for answers? Try searching our database.

Simple scatter style chart help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy the Yeti - 09 Aug 2006 13:40 GMT
Hi, this may get the stupid post of the day award! But I hope someone can
point me in the right direction, I am trying to create a simple chart. That
will read from just two sets of data.

for example:
    X    Y   
A    210    5
B    350    7       
C    422    10   
D    100    3   
E    127    6   
F    499    1

So using the above data, I would like to create a chart that will place a
single marker for where each of the points meet for A B C etc. When I try
using scatter charts I  get two points for each line (ie A, B etc)

Thank for any help or direction
regards
Andy
Andy Pope - 10 Aug 2006 08:47 GMT
Hi,

Create your xy-scatter chart using the chart wizard but only select the
actual xy values when you do it.

If you then want to have data labels which display A, B, C etc you will
need to either link the data labels to the cells manually.
http://www.andypope.info/tips/tip001.htm

Or better still use one of these free addin.

Rob Bovey's XY Chart Labeler from
http://www.appspro.com/Utilities/ChartLabeler.htm and

John Walkenbach's Chart Tools
http://j-walk.com/ss/excel/files/charttools.htm

Cheers
Andy

> Hi, this may get the stupid post of the day award! But I hope someone can
> point me in the right direction, I am trying to create a simple chart. That
[quoted text clipped - 16 lines]
> regards
> Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.