台灣最大程式設計社群網站
線上人數
2358
 
會員總數:245963
討論主題:189547
歡迎您免費加入會員
討論區列表 >> 專欄文章 >> 圖表製作方式(折線圖,曲線圖,區域圖)
[]  
[我要回覆]
回應主題 加入我的關注話題 檢舉此篇討論 將提問者加入個人黑名單
圖表製作方式(折線圖,曲線圖,區域圖)
價值 : 0 QP  點閱數:892 回應數:0
樓主

站務人員 站長
門外漢
0 1580
542 9
發送站內信

捐贈 VP 給 站務人員
更正事項 : 於2002/6/17所張貼 "圖表製作方式(雷達圖,曲線圖)"
其中檔案名稱 graphic3*.txt 計6個檔案應為折線圖,請注意
使用方法請參考2002/6/15發表 圖表製作方式

*以下檔案內容不可修改

曲線圖 Smooth Line Standard

檔案名稱 graphic4.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Smooth</x:SubType>

<x:Type>Line</x:Type>

<x:SubType>Standard</x:SubType>

chgdatasource

<x:ScaleID>184924136</x:ScaleID>

<x:ScaleID>184924276</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>184924416</x:AxisID>

<x:ScaleID>184924276</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>184924812</x:AxisID>

<x:ScaleID>184924136</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>184924136</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>184924276</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">


曲線圖 Smooth Line Standard Marker

檔案名稱 graphic4-1.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Smooth</x:SubType>

<x:Type>Line</x:Type>

<x:SubType>Standard</x:SubType>

<x:SubType>Marker</x:SubType>

chgdatasource

<x:ScaleID>219777884</x:ScaleID>

<x:ScaleID>219778024</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>219778164</x:AxisID>

<x:ScaleID>219778024</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>219778560</x:AxisID>

<x:ScaleID>219777884</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>219777884</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>219778024</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">


曲線圖 Smooth Line Stacked

檔案名稱 graphic4-2.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Smooth</x:SubType>

<x:Type>Line</x:Type>

<x:SubType>Stacked</x:SubType>

chgdatasource

<x:ScaleID>255128688</x:ScaleID>

<x:ScaleID>255128828</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>255128968</x:AxisID>

<x:ScaleID>255128828</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>255129364</x:AxisID>

<x:ScaleID>255128688</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>255128688</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>255128828</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">


曲線圖 Smooth Line 100% Stacked

檔案名稱 graphic4-3.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Smooth</x:SubType>

<x:Type>Line</x:Type>

<x:SubType>100% Stacked</x:SubType>

chgdatasource

<x:ScaleID>264769288</x:ScaleID>

<x:ScaleID>264769428</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>264772468</x:AxisID>

<x:ScaleID>264769428</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>0%</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>264772800</x:AxisID>

<x:ScaleID>264769288</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>264769288</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>264769428</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">


曲線圖 Smooth Line Stacked Marker

檔案名稱 graphic4-4.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Smooth</x:SubType>

<x:Type>Line</x:Type>

<x:SubType>Stacked</x:SubType>

<x:SubType>Marker</x:SubType>

chgdatasource

<x:ScaleID>264784824</x:ScaleID>

<x:ScaleID>264784964</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>264785104</x:AxisID>

<x:ScaleID>264784964</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>264785500</x:AxisID>

<x:ScaleID>264784824</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>264784824</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>264784964</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">


曲線圖 Smooth Line 100% Stacked Marker

檔案名稱 graphic4-5.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Smooth</x:SubType>

<x:Type>Line</x:Type>

<x:SubType>100% Stacked</x:SubType>

<x:SubType>Marker</x:SubType>

chgdatasource

<x:ScaleID>264796728</x:ScaleID>

<x:ScaleID>264796868</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>264797008</x:AxisID>

<x:ScaleID>264796868</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>0%</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>264797404</x:AxisID>

<x:ScaleID>264796728</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>264796728</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>264796868</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">


區域圖 Standard Area

檔案名稱 graphic5.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Standard</x:SubType>

<x:Type>Area</x:Type>

chgdatasource

<x:ScaleID>195629148</x:ScaleID>

<x:ScaleID>195629288</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>195629428</x:AxisID>

<x:ScaleID>195629288</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>195629824</x:AxisID>

<x:ScaleID>195629148</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>195629148</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>195629288</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">



區域圖 Stacked Area

檔案名稱 graphic5-1.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>Stacked</x:SubType>

<x:Type>Area</x:Type>

chgdatasource

<x:ScaleID>3550824</x:ScaleID>

<x:ScaleID>3550964</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>3546876</x:AxisID>

<x:ScaleID>3550964</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>General</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>3547144</x:AxisID>

<x:ScaleID>3550824</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>3550824</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>3550964</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">



區域圖 100% Stacked Area

檔案名稱 graphic5-1.txt (注意儲存為 txt檔案) :

<param name="XMLData" value="<xml xmlns:x='urn:schemas-microsoft-com:office:excel'>

<x:WebChart>

<x:OWCVersion>9.0.0.2710</x:OWCVersion>

<x:Width>15240</x:Width>

<x:Height>10160</x:Height>

<x:DataSource>

<x:Type>OSP</x:Type>

</x:DataSource>

<x:Border>

<x:Color>#000000</x:Color>

</x:Border>

<x:Chart>

<x:PlotArea>

<x:Graph>

<x:SubType>100% Stacked</x:SubType>

<x:Type>Area</x:Type>

chgdatasource

<x:ScaleID>3566788</x:ScaleID>

<x:ScaleID>3566928</x:ScaleID>

<x:Overlap>100</x:Overlap>

<x:GapWidth>150</x:GapWidth>

<x:FirstSliceAngle>0</x:FirstSliceAngle>

</x:Graph>

<x:Axis>

<x:AxisID>3567068</x:AxisID>

<x:ScaleID>3566928</x:ScaleID>

<x:Type>Value</x:Type>

<x:Number>

<x:FormatString>0%</x:FormatString>

</x:Number>

<x:MajorGridlines>

</x:MajorGridlines>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Left</x:Placement>

</x:Axis>

<x:Axis>

<x:AxisID>3567464</x:AxisID>

<x:ScaleID>3566788</x:ScaleID>

<x:Type>Category</x:Type>

<x:MajorTick>Outside</x:MajorTick>

<x:MinorTick>None</x:MinorTick>

<x:Placement>Bottom</x:Placement>

</x:Axis>

</x:PlotArea>

<x:Legend>

<x:Placement>Right</x:Placement>

</x:Legend>

</x:Chart>

<x:Scaling>

<x:ScaleID>3566788</x:ScaleID>

</x:Scaling>

<x:Scaling>

<x:ScaleID>3566928</x:ScaleID>

</x:Scaling>

</x:WebChart>

</xml>">

<param name="ScreenUpdating" value="-1">
本篇文章發表於2002-06-18 00:00
目前尚無任何回覆
   

回覆
如要回應,請先登入.