<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/94128322-48e8-455d-86bc-724d8ab83ac8/61B3D4CD-923B-4906-B104-BCFEF67F3CF4/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.wretch.cc/blog/tivo168/11626876" href="http://www.wretch.cc/blog/tivo168/11626876" style="font-size: 11px;">www.wretch.cc</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.wretch.cc/blog/tivo168/11626876"><H3 class="title">[Lesson 001] 如何用EXCEL製作 3個月及12個月平均營收？</H3> <DIV class="innertext"> <P><DIV><B>如何用EXCEL製作下圖這張3個月及12個月平均營收圖表呢？</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987249.jpg" /> <BR /> <BR /><B>STEP01：找出歷史營收資料，選取然後複製貼到EXCEL上。</B><BR /><DIV><A target="_blank" href="http://dj.mybank.com.tw/z/zc/zch/zch_2409.asp.htm">http://dj.mybank.com.tw/z/zc/zch/zch_2409.asp.htm</A></DIV><BR /><DIV>P.S.如果你的 EXCEL 是 2000以上的版本，請將滑鼠移到月營收明細的表格，然後按滑鼠右鍵，選「匯出到EXCEL…」 </DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987224.jpg" /> <BR /> <BR /><DIV><B>STEP02：將月營收資料複製到EXCEL工作表上。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987225.jpg" /> <BR /> <BR /><DIV><B>STEP03：「排序」營收資料。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987226.jpg" /> <BR /> <BR /><DIV><B>STEP04：由過去到現在，所以選「遞增」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987227.jpg" /> <BR /> <BR /><DIV><B>STEP05：修改A欄日期格式(讓它看起來正確)</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987228.jpg" /> <BR /> <BR /><DIV><B>STEP06：選取A及B兩欄，點選「圖表精靈」</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987247.jpg" /> <BR /> <BR /><DIV><B>STEP07：選取「直條圖」，按「下一步」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987230.jpg" /> <BR /> <BR /><DIV><B>STEP08：按「下一步」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987231.jpg" /> <BR /> <BR /><DIV><B>STEP09：選「標題」頁，修改「圖表標題」、「類別 X 軸」及「數值 Y 軸」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987232.jpg" /> <BR /> <BR /><DIV><B>STEP10：選「座標軸」頁，類別 X 軸選「類別」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987233.jpg" /> <BR /> <BR /><DIV><B>STEP11：選「圖例」頁，位置在「上」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987234.jpg" /> <BR /> <BR /><DIV><B>STEP12：按「下一步」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987235.jpg" /> <BR /> <BR /><DIV><B>STEP13：看看初步圖表成果。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987236.jpg" /> <BR /> <BR /><DIV><B>STEP14：選取「直條圖」物件。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987237.jpg" /> <BR /> <BR /><DIV><B>STEP15：按滑鼠右鍵，選「加上趨勢線...」</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987238.jpg" /> <BR /> <BR /><DIV><B>STEP16：選「移動平均線」，「週期」改為3，確定離開。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987239.jpg" /> <BR /> <BR /><DIV><B>STEP17：選取那條線，按滑鼠右鍵，選「趨勢線格式」。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987248.jpg" /> <BR /> <BR /><DIV><B>STEP18：選「圖樣」頁，改變色彩及粗細。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987241.jpg" /> <BR /> <BR /><DIV><B>STEP19：選「選項」頁，自訂趨勢線名稱，按確定離開。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987242.jpg" /> <BR /> <BR /><DIV><B>STEP20：看看 3個月平均營收線。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987243.jpg" /> <BR /> <BR /><DIV><B>STEP21：相同做法，請自己加上12個月平均營收線</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987244.jpg" /> <BR /> <BR /><DIV><B>STEP22：劃出長短期移動平均線了。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987245.jpg" /> <BR /> <BR /><DIV><B>STEP23：做一下圖表細部格式設定，讓它看起來更有型。</B></DIV> <IMG border="0" src="http://f9.wretch.yimg.com/tivo168/32764/1127987249.jpg" /> <BR /></P></DIV></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/61B3D4CD-923B-4906-B104-BCFEF67F3CF4/blog/" title="blog or email this clip"><img src="http://content6.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks:  Amplify.com - Don't just share the news...Amplify it!