Hi,
You will need 3 columns of data.
Column A contains x axis labels
Column B contains data with values in the range 0 to 1000
Column C contains data with values in the range 0 to 0.0001
Select all the data and use the chart wizard to create a line chart.
Select the 2nd series, one with the values 0 to 0.0001, press CTRL+1 to
bring up the format dialog. On the Axis tab choose Secondary axis.
If you want a chart type of column then you will need to stagger your
data in order to avoid overlapping columns.
See Jon Peltier's page of links for more information on cluster &
stacked column charts.
http://peltiertech.com/Excel/ChartsH...sterStack.html
Cheers
Andy
ramki wrote:
hi can any one help me in creating a chart with 2 diff. y axis scales
like 0 to 1000 and 0 to 0.001 but x axis being the same or vice versa
please
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info