Chart with two series, one high, one low
 

Hi,

I have some data that i would like to present in a chart form. The problem
i have is that it is based on sales leads, so a lead provider, may generate
say 5 leads, but that will have revenue value in the thousands. When i plot
the two, the leads data is meaningless cause of the scale of the axis.

Can i have two axis, one on the left for the thousands, and one on the right
for the leads.

Thanks

Chart with two series, one high, one low
 

Select one of the series, then Format Data Series/ Axis, and select
Secondary.
--
David Biddulph

"nathan_savidge" wrote in message
...
Hi,

I have some data that i would like to present in a chart form. The
problem
i have is that it is based on sales leads, so a lead provider, may
generate
say 5 leads, but that will have revenue value in the thousands. When i
plot
the two, the leads data is meaningless cause of the scale of the axis.

Can i have two axis, one on the left for the thousands, and one on the
right
for the leads.

Thanks

Chart with two series, one high, one low
 

This will show you how to design a graph using a secondary axis:
http://www.computorcompanion.com/LPMArticle.asp?ID=211
Remember, you want to double-click on one of the lines, bars, etc., and then
click 'axis' and then click 'secondary axis'. How much value added is
questionable. I've used these with some success; some people find these
types of charts confusing.

Regards,
Ryan--

--
RyGuy


"David Biddulph" wrote:

Select one of the series, then Format Data Series/ Axis, and select
Secondary.
--
David Biddulph

"nathan_savidge" wrote in message
...
Hi,

I have some data that i would like to present in a chart form. The
problem
i have is that it is based on sales leads, so a lead provider, may
generate
say 5 leads, but that will have revenue value in the thousands. When i
plot
the two, the leads data is meaningless cause of the scale of the axis.

Can i have two axis, one on the left for the thousands, and one on the
right
for the leads.

Thanks