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

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

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