语言:VBScript 、C#
步骤:
1.单击“工具箱-添加/移除项”,弹出“自定义工具箱”;
2.点击“COM组件”,选择“Microsoft Office Chart 11.0”然后确定,此时工具栏上出现“Microsoft Office Chart 11.0”的图标;
3..aspx的后台代码如下:
<HTML>
<HEAD>
<title>OfficeChart1</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server"></form>
<OBJECT id="ChartSpace1" style="Z-INDEX: 101; LEFT: 40px; WIDTH: 432px; POSITION: absolute; TOP: 40px; HEIGHT: 280px"
classid="clsid:0002E55D-0000-0000-C000-000000000046" VIEWASTEXT>
<PARAM NAME="XMLData" VALUE='<xml xmlns:x="urn:schemas-microsoft-com:office:excel"> <x:ChartSpace> <x:OWCVersion>11.0.0.5531 </x:OWCVersion> <x:Width>11430</x:Width> <x:Height>7408</x:Height> <x:Palette> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#000000</x:Entry> <x:Entry>#8080FF</x:Entry> <x:Entry>#802060</x:Entry> <x:Entry>#FFFFA0</x:Entry> <x:Entry>#A0E0E0</x:Entry> <x:Entry>#600080</x:Entry> <x:Entry>#FF8080</x:Entry> <x:Entry>#008080</x:Entry> <x:Entry>#C0C0FF</x:Entry> <x:Entry>#000080</x:Entry> <x:Entry>#FF00FF</x:Entry> <x:Entry>#80FFFF</x:Entry> <x:Entry>#0080FF</x:Entry> <x:Entry>#FF8080</x:Entry> <x:Entry>#C0FF80</x:Entry> <x:Entry>#FFC0FF</x:Entry> <x:Entry>#FF80FF</x:Entry> </x:Palette> <x:DefaultFont>宋体</x:DefaultFont> </x:ChartSpace> </xml>'>
<PARAM NAME="ScreenUpdating" VALUE="-1">
<PARAM NAME="EnableEvents" VALUE="-1">
</OBJECT>
<script language="vbscript">
Dim categories, values1,values2
categories = "0"+chr(9)+"1"+chr(9)+"2"+chr(9)+"3"+chr(9)+"4"+chr(9)+"5"+chr(9)+"6"+chr(9)+"7"+chr(9)+"8"+chr(9)+"9"+chr(9)
values1 = "2"+chr(9)+"2"+chr(9)+"3"+chr(9)+"4"+chr(9)+"2"+chr(9)+"12"+chr(9)+"3"+chr(9)+"2"+chr(9)+"3"+chr(9)+"4"+chr(9)
ChartSpace1.Charts.Add '将图表添加到图表工作区中
Set c = ChartSpace1.Constants
ChartSpace1.Charts(0).hastitle=true '图表有标题
ChartSpace1.Charts(0).Title.Font.Name = "仿宋_GB231280" '标题字体
ChartSpace1.Charts(0).Title.Font.size=12 '标题字体大小
ChartSpace1.Charts(0).Title.caption="某某业务分析表" '标题内容
ChartSpace1.Charts(0).HasLegend = True '指定图表具有图例
ChartSpace1.Charts(0).type=1 '指定图表的图形方式为列状图
ChartSpace1.Charts(0).SeriesCollection.Add '向图表中添加
ChartSpace1.Charts(0).SetData c.chDimCategories, c.chDataLiteral,categories '给图表赋横坐标的值
ChartSpace1.Charts(0).SeriesCollection(0).Caption="数据" '图例
ChartSpace1.Charts(0).SeriesCollection(0).SetData c.chDimValues, c.chDataLiteral, values1 '给图表赋纵坐标的值
ChartSpace1.Charts(0).SeriesCollection(0).Border.Color="#000000"'设置图形的边框颜色
ChartSpace1.Charts(0).SeriesCollection(0).Interior.Color="#ff0000" '设置图形的填充色,这个找了好长时间。^_^
'指定纵坐标轴有标题,并赋值,然后指定数据的显示格式
ChartSpace1.Charts(0).axes(c.chAxisPositionLeft).hastitle=true
ChartSpace1.Charts(0).axes(c.chAxisPositionLeft).title.caption="数量"
ChartSpace1.Charts(0).Axes(c.chAxisPositionLeft).NumberFormat = "0.##"
'指定横坐标轴有标题,并赋值
ChartSpace1.Charts(0).axes(c.chAxisPositionBottom).hastitle=true
ChartSpace1.Charts(0).axes(c.chAxisPositionBottom).title.caption="时间"
</script>
</body>
</HTML>
柱图:
注意:
1。<OBJECT>控件放在<form>外,负责提示“缺少对象”的错误!
2。修改柱子的颜色:Interior.Color
3。categories和values1从数据库中的读取方法:
categories="<%=Categories%>"
values1="<%=values1%>"
其中的Categories和values1是后台定义的全局(string类型)变量,赋上相应值即可,注意要用制表符分割。C#中的制表符:(char)(9)
4。图类型:
1-5 普通柱子
6-11 折线
12-17 正弦线
18-20 饼图
21-26 分散
27-28 气泡
29-31 填充
32-33 油炸圈饼
34-38 雷达线
39-40
41-45 北极图
46-53 立体柱图
54-57 立体折线图
58-59 立体饼图
60-63 立体填充图
chChartTypeCombo -1
chChartTypeColumnClustered 0
chChartTypeColumnStacked 1
chChartTypeColumnStacked100 2
chChartTypeBarClustered 3
chChartTypeBarStacked 4
chChartTypeBarStacked100 5
chChartTypeLine 6
chChartTypeLineMarkers 7
chChartTypeLineStacked 8
chChartTypeLineStackedMarkers 9
chChartTypeLineStacked100 10
chChartTypeLineStacked100Markers 11
chChartTypeSmoothLine 12
chChartTypeSmoothLineMarkers 13
chChartTypeSmoothLineStacked 14
chChartTypeSmoothLineStackedMarkers 15
chChartTypeSmoothLineStacked100 16
chChartTypeSmoothLineStacked100Markers 17
chChartTypePie 18
chChartTypePieExploded 19
chChartTypePieStacked 20
chChartTypeScatterMarkers 21
chChartTypeScatterSmoothLineMarkers 22
chChartTypeScatterSmoothLine 23
chChartTypeScatterLineMarkers 24
chChartTypeScatterLine 25
chChartTypeScatterLineFilled 26
chChartTypeBubble 27
chChartTypeBubbleLine 28
chChartTypeArea 29
chChartTypeAreaStacked 30
chChartTypeAreaStacked100 31
chChartTypeDoughnut 32
chChartTypeDoughnutExploded 33
chChartTypeRadarLine 34
chChartTypeRadarLineMarkers 35
chChartTypeRadarLineFilled 36
chChartTypeRadarSmoothLine 37
chChartTypeRadarSmoothLineMarkers 38
chChartTypeStockHLC 39
chChartTypeStockOHLC 40
chChartTypePolarMarkers 41
chChartTypePolarLine 42
chChartTypePolarLineMarkers 43
chChartTypePolarSmoothLine 44
chChartTypePolarSmoothLineMarkers 45