software

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

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 amp;
stacked column charts.
peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

ramki wrote:
gt; hi can any one help me in creating a chart with 2 diff. y axis scales
gt; like 0 to 1000 and 0 to 0.001 but x axis being the same or vice versa
gt; please
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

yeah that worked thank youvery much Andy

bye

quot;Andy Popequot; wrote:

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

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

quot;Andy Popequot; wrote:

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

Hi,

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

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info