Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 04, 04:35 PM
Kevin McCartney
 
Posts: n/a
Default HOW TO: Plot a Team Name on a chart based on two values

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.


  #2   Report Post  
Old November 30th 04, 05:26 PM
Barb Reinhardt
 
Posts: n/a
Default

I've done this using Ron Bovey's XY Chart Labeler

www.appspro.com

"Kevin McCartney" wrote in
message ...
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.





Reply
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
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 1 November 29th 04 11:21 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 05:13 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017