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

K

Kevin McCartney

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Barb Reinhardt: HOW TO: Plot a Team Name .... 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Cumulative chart 1
How To: Easy Box Plot 5
Graph won't interpolate? 4
Auto calculate 1
How to create a 3D surface graph from 3 columns of data: one columnfor x, one for y, and one for z 3
Update values from one column to another 1

Top