Chart with two series, one high, one low

[nathan_savidge]

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

 

[David Biddulph]

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

 

[ryguy7272]

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--