<P>Hi,<BR>i have a small problem in charting in Excel 2000. sorry for posting it here but i hope some one has used it to consolidate their work....</P>
<P>i have 4 columns of data, ( all are numbers). i need to set col2 n 3 as y axes and col 4 as the secondary axis as its on a diff scale. but i am not able to set the secondary axis option. i followed the instructions i found in "Excel 2002: The complete reerence"(pg:313) which are as under:<BR><pre><BR>To get sec axis, take these steps:<BR>1. Ensure that the values in col A are text not nums.<BR>2. Select thedata on the worksheet. (select A1:C10)<BR>3. Use chart wizard to create a column chart.<BR>4. If u can see the sec dta series on the chart, select it by clicking.<BR>5. choose Chart | Chart type. Set the selected data series to a line chart type. click ok<BR>6. Select the sec data series again. Choose Format | Selected data series<BR>7. on the axis tab, select sec Axis<BR>8. Click OK.<BR></pre><BR>Step 1 ok. i change the format of the cells to text... but from step4 onwards, i am left out cos i can *see* any such thing as described. i have Excel 2000, does any one use 2002? if so can u plz check if the foll data from the book works so that i can conclude that 2000 doesnt support the feature? or if 2000 does, then how do i make use of it? this test data (shown in the book) doesnt work either, leave alone "my" data...<BR><pre><BR>Year | Housing Starts | Median price<BR>1994 | 440 | $ 70,210 (this is the format, col1 is text, 2 is right aligned so must be either general or integer not mentioned explicitly, n 3 is curreny formatted)<BR>1995 | 336 | 70932<BR>1996 | 229 | 71251<BR>1997 | 215 | 86232<BR>1998 | 335 | 88303<BR>1999 | 265 | 95120<BR>2000 | 296 | 102331<BR>2001 | 357 | 115687<BR>2002 | 345 | 133224<BR></pre></P>
<P>Apologies again,<BR>Tracy</P><BR><BR>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>Coming together is a beginning... <br> keeping together is progress... <br> working together is success !!!<br>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<p><br><hr size=1>Do you Yahoo!?<br>
<a href="http://rd.yahoo.com/platinum/evt=8162/*http://platinum.yahoo.com/splash.html">Yahoo! Platinum</a> - Watch CBS' NCAA March Madness, <a href="http://rd.yahoo.com/platinum/evt=8162/*http://platinum.yahoo.com/splash.html">live on your desktop</a>!