how to creat a chart with t diffrrent scales

[ramki]

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]

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/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Guest]

yeah that worked thank youvery much Andy

bye

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/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Guest]

what if i have to creat an Xy scatter chart and still have 2 differrent y
axis or 2 differrent x axis can you tell me? please

 

[Andy Pope]

Hi,

See this page for details on how to display the secondary x axis.
http://www.andypope.info/tips/tip008.htm

Cheers
Andy