View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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