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 / November 2004

Tip: Looking for answers? Try searching our database.

HOW TO: Plot a Team Name on a chart based on two values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin McCartney - 30 Nov 2004 16:35 GMT
Hi,

I have the following table exmaple, what I like to do is to plot the team
as where their values cross, e.g. for TEAM 01 where 5 and 60 cross on a graph
having Revenue as the Y axis and Clients as the X axis.

COLUMN A COLUMN B COLUMN C
TEAMS    CLIENTS    REVENUE
TEAM 01    5    60
TEAM 02    10    120
TEAM 03    15    180
TEAM 04    6    72
TEAM 05    12    144
TEAM 06    18    216
TEAM 07    7    84
TEAM 08    14    168
TEAM 09    21    252
TEAM 10    8    96

Any guidence, much appriciated.
Barb Reinhardt - 30 Nov 2004 17:26 GMT
I've done this using Ron Bovey's XY Chart Labeler

www.appspro.com

> Hi,
>
[quoted text clipped - 16 lines]
>
> Any guidence, much appriciated.
 
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



©2008 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.