(1)餅狀圖:----通過修改參數(shù)生成不同的走勢圖,
? string strCategory = "優(yōu)良率" + '\t' + "合格率" + '\t' + "不合格率";
??????? string strValue = a.ToString("F3") + '\t' + b.ToString("F3") + '\t' + c.ToString("F3");
??????? string path=Server.MapPath("~/File/Graphs");
??????? string mTitle = "施工安全評定等級餅形圖";
??????? string xTitle = "";
??????? string yTitle = "";
??????? int imgWidth = 1000;
??????? int imgHeight =400;
??????? int chartType = 18;//設(shè)置生成圖表的種類
??????? // this.CreateChartSmoothLine(strCategory,strValue,mTitle,xTitle,yTitle,imgWidth,imgHeight,chartType);
??????? FishPro.OWCChart11 chart = new OWCChart11(path, "評級", mTitle,chartType, xTitle, yTitle, imgWidth, imgHeight);
??????? chart.OCategory = strCategory;
??????? chart.OValue = strValue;
??????? if (chart.Create())
??????? {
??????????? this.Image1.ImageUrl ="~/File/Graphs/"+chart.FileName;
??????? }
??????? else
??????? {
??????????? Messabox.ShowError(this, "生成失敗");
??????
?
(2)添加類:
??? public class OWCChart11
??????? {
??????????? #region 屬性
??????????? private string m_SavePath;
??????????? private string m_Category;
??????????? private string m_Value;
??????????? private DataTable m_DataSource;
??????????? private string m_SeriesName;
??????????? private string m_Title;
??????????? private string m_AxesXTitle;
??????????? private string m_AxesYTitle;
??????????? private int m_PicWidth;
??????????? private int m_PicHeight;
??????????? private int m_Type;
??????????? private string m_FileName;
?
??????????? /**/
??????????? /// <summary>
??????????? /// 保存圖片的路徑和名稱,物理路徑
??????????? /// </summary>
??????????? public string SavePath
??????????? {
??????????????? get { return m_SavePath; }
??????????????? set { m_SavePath = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 直接獲得類型
??????????? /// </summary>
??????????? public string OCategory
??????????? {
??????????????? get { return m_Category; }
??????????????? set { m_Category = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 直接獲得值
??????????? /// </summary>
??????????? public string OValue
??????????? {
??????????????? get { return m_Value; }
??????????????? set { m_Value = value; }
??????????? }
?
?
??????????? /**/
??????????? /// <summary>
??????????? /// 以表格DataTable的形式獲取原始數(shù)據(jù)
??????????? /// </summary>
??????????? public DataTable DataSource
??????????? {
??????????????? get { return m_DataSource; }
??????????????? set
??????????????? {
??????????????????? m_DataSource = value;
??????????????????? m_Category = GetColumnsStr(m_DataSource);
??????????????????? m_Value = GetValueStr(m_DataSource);
??????????????? }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 簡要說明
??????????? /// </summary>
??????????? public string SeriesName
??????????? {
??????????????? get { return m_SeriesName; }
??????????????? set { m_SeriesName = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 圖表的總標題,說明圖表的簡單意思
??????????? /// </summary>
??????????? public string Title
??????????? {
??????????????? get { return m_Title; }
??????????????? set { m_Title = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 圖表橫坐標標題,說明橫坐標的意義
??????????? /// </summary>
??????????? public string AxesXTitle
?????? ?????{
??????????????? get { return m_AxesXTitle; }
??????????????? set { m_AxesXTitle = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 圖表縱坐標標題,說明縱坐標的意義
??????????? /// </summary>
??????????? public string AxesYTitle
??????????? {
??????????????? get { return m_AxesYTitle; }
??????????????? set { m_AxesYTitle = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? ///? 生成的圖片寬度
??????????? /// </summary>
??????????? public int PicWidth
???????? ???{
??????????????? get { return m_PicWidth; }
??????????????? set { m_PicWidth = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? ///? 生成的圖片高度
??????????? /// </summary>
??????????? public int PicHeight
??????????? {
?????? ?????????get { return m_PicHeight; }
??????????????? set { m_PicHeight = value; }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 類型
??????????? /// chChartTypeColumnStacked100 =2
??????????? ///chChartTypeColumnStacked1003D = 49
??????????? ///chChartTypeColumnStacked3D = 48
??????????? ///chChartTypeCombo = -1
??????????? ///chChartTypeCombo3D = -2
??????????? ///chChartTypeDoughnut = 32
??????????? ///chChartTypeDoughnutExploded = 33
??????????? ///chChartTypeLine = 6
??????????? ///chChartTypeLine3D = 54
??????????? ///chChartTypeLineMarkers=? 7
??????????? ///chChartTypeLineOverlapped3D=? 55
??????????? ///chChartTypeLineStacked = 8
??????????? ///chChartTypeLineStacked100? =10
??????????? ///chChartTypeLineStacked1003D=? 57
??????????? ///chChartTypeLineStacked100Markers = 11
??????????? ///chChartTypeLineStacked3D = 56
??????????? ///chChartTypeLineStackedMarkers = 9
??????????? ///chChartTypePie = 18
???????? ???///chChartTypePie3D =58
??????????? ///chChartTypePieExploded = 19
??????????? ///chChartTypePieExploded3D = 59
??????????? ///chChartTypePieStacked = 20
??????????? ///chChartTypePolarLine = 42
??????????? ///chChartTypePolarLineMarkers = 43
??? ????????///chChartTypePolarMarkers = 41
??????????? ///chChartTypePolarSmoothLine = 44
??????????? ///chChartTypePolarSmoothLineMarkers = 45
??????????? ///chChartTypeRadarLine=? 34
??????????? ///chChartTypeRadarLineFilled = 36
??????????? ///chChartTypeRadarLineMarkers=? 35
??????????? ///chChartTypeRadarSmoothLine = 37
??????????? ///chChartTypeRadarSmoothLineMarkers = 38
??????????? ///chChartTypeScatterLine = 25
??????????? ///chChartTypeScatterLineFilled = 26
????????? ??///chChartTypeScatterLineMarkers = 24
??????????? ///chChartTypeScatterMarkers = 21
??????????? ///chChartTypeScatterSmoothLine = 23
??????????? ///chChartTypeScatterSmoothLineMarkers = 22
??????????? ///chChartTypeSmoothLine = 12
??????????? ///chChartTypeSmoothLineMarkers = 13
??????????? ///chChartTypeSmoothLineStacked = 14
??????????? ///chChartTypeSmoothLineStacked100 = 16
??????????? ///chChartTypeSmoothLineStacked100Markers = 17
??????????? ///chChartTypeSmoothLineStackedMarkers = 15
??? ????????///chChartTypeStockHLC = 39
??????????? ///chChartTypeStockOHLC = 40
??????????? /// </summary>
??????????? public int Type
??????????? {
??????????????? get { return m_Type; }
??????????????? set { m_Type = value; }
??????????? }
?
??????????? public string FileName
??????????? {
??????????????? get { return m_FileName; }
??????????????? set
??????????????? {
??????????????????? m_FileName = value;
??????????????????? if (m_FileName == null || m_FileName == "")
??????????????????? {
??????????????????????? m_FileName = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".gif";//生成圖片名稱
??????????????????? }
??????????????? }
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 是DataTable的轉(zhuǎn)換
??????????? /// </summary>
??? ????????/// <param name="dt"></param>
??????????? /// <returns></returns>
??????????? private string GetColumnsStr(DataTable dt)
??????????? {
??????????????? StringBuilder strList = new StringBuilder();
??????????????? foreach (DataRow r in dt.Rows)
???? ???????????{
??????????????????? strList.Append(r[0].ToString() + '\t');
??????????????? }
??????????????? return strList.ToString();
??????????? }
?
??????????? /**/
??????????? /// <summary>
??????????? /// 是DataTable的轉(zhuǎn)換
??????????? /// </summary>
??????????? /// <param name="dt"></param>
??????????? /// <returns></returns>
??????????? private string GetValueStr(DataTable dt)
??????????? {
??????????????? StringBuilder strList = new StringBuilder();
??????????????? foreach (DataRow r in dt.Rows)
?? ?????????????{
??????????????????? strList.Append(r[1].ToString() + '\t');
??????????????? }
??????????????? return strList.ToString();
??????????? }
?
??????????? #endregion
?
??????????? #region 枚舉類型
??????????? /**/
??????????? /// <summary>
??????????? /// 枚舉類型 對應(yīng)于OWC的圖表類型
??????????? /// </summary>
??????????? public enum ChartType : int
??????????? {
?
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 面積圖
??????????????? /// </summary>
??????????????? chChartTypeArea = 29,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 面積圖3D
??????????????? /// </summary>
??????????????? chChartTypeArea3D = 60,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 面積圖重復(fù)
??????????????? /// </summary>
??????????????? chChartTypeAreaOverlapped3D = 61,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆積面積圖
??????????????? /// </summary>
??????????????? chChartTypeAreaStacked = 30,
??????????????? /**/
??????????????? /// <summary>
? ??????????????/// 堆積面積圖百分比圖
??????????????? /// </summary>
??????????????? chChartTypeAreaStacked100 = 31,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆積面積圖百分比圖3D
??????????????? /// </summary>
??????????????? chChartTypeAreaStacked1003D = 63,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆積面積圖3D
??????????????? /// </summary>
??????????????? chChartTypeAreaStacked3D = 62,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 橫道圖3D
??????????????? /// </summary>
??????????????? chChartTypeBar3D = 50,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 橫道圖串風格
??????????????? /// </summary>
??????????????? chChartTypeBarClustered = 3,
??????????????? /**/
?????????? ?????/// <summary>
??????????????? /// 橫道圖串風格3D
??????????????? /// </summary>
??????????????? chChartTypeBarClustered3D = 51,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆橫道圖
??????????????? /// </summary>
??????????????? chChartTypeBarStacked = 4,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆橫道圖百分比圖
??????????????? /// </summary>
??????????????? chChartTypeBarStacked100 = 5,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆橫道圖百分比圖3D
??????????????? /// </summary>
??????????????? chChartTypeBarStacked1003D = 53,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 堆橫道圖3D
??????????????? /// </summary>
??????????????? chChartTypeBarStacked3D = 52,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 氣泡圖
??????????????? /// </summary>
??????????????? chChartTypeBubble = 27,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 線形氣泡圖
??????????????? /// </summary>
? ??????????????chChartTypeBubbleLine = 28,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumn3D = 46,
??????????????? /**/
??????????????? /// <summary>
?????????????? ?/// 3D柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumnClustered = 0,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 3D串柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumnClustered3D = 47,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 重疊柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumnStacked = 1,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 100%重疊柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumnStacked100 = 2,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 100%3D重疊柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumnStacked1003D = 49,
??????????????? /**/
????????? ??????/// <summary>
??????????????? /// 3D柱形圖
??????????????? /// </summary>
??????????????? chChartTypeColumnStacked3D = 48,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 組合圖
??????????????? /// </summary>
??????????????? chChartTypeCombo = -1,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 3D組合圖
??????????????? /// </summary>
??????????????? chChartTypeCombo3D = -2,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 環(huán)形圖
??????????????? /// </summary>
??????????????? chChartTypeDoughnut = 32,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 破式環(huán)形圖
??????????????? /// </summary>
??????????????? chChartTypeDoughnutExploded = 33,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 折線圖
??????????????? /// </summary>
??????????????? chChartTypeLine = 6,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 3D折線圖
??????????????? /// </summary>
??????????????? chChartTypeLine3D = 54,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineMarkers = 7,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 重復(fù)折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineOverlapped3D = 55,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 重疊折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineStacked = 8,
??????????????? /**/
? ??????????????/// <summary>
??????????????? /// 100%重疊折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineStacked100 = 10,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 100%3D重疊折線圖
??????????????? /// </summary>
???? ???????????chChartTypeLineStacked1003D = 57,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造100%重疊折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineStacked100Markers = 11,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 3D重疊折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineStacked3D = 56,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造重疊折線圖
??????????????? /// </summary>
??????????????? chChartTypeLineStackedMarkers = 9,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 餅圖
??????????????? /// </summary>
??????????????? chChartTypePie = 18,
??????????????? /**/
??????????????? /// <summary>
??????????? ????/// 3D餅圖
??????????????? /// </summary>
??????????????? chChartTypePie3D = 58,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 破式餅圖
??????????????? /// </summary>
??????????????? chChartTypePieExploded = 19,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 3D破式餅圖
??????????????? /// </summary>
??????????????? chChartTypePieExploded3D = 59,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 重疊餅圖
??????????????? /// </summary>
??????????????? chChartTypePieStacked = 20,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 極坐標圖
??????????????? /// </summary>
??????????????? chChartTypePolarLine = 42,
??????????????? /**/
??????????????? /// <summary>
?????????? ?????/// 制造線形極坐標圖
??????????????? /// </summary>
??????????????? chChartTypePolarLineMarkers = 43,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造極坐標圖
??????????????? /// </summary>
??????????????? chChartTypePolarMarkers = 41,
? ??????????????/**/
??????????????? /// <summary>
??????????????? /// 平滑線形極坐標圖
??????????????? /// </summary>
??????????????? chChartTypePolarSmoothLine = 44,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造平滑線形極坐標圖
??????????????? /// </summary>
??????????????? chChartTypePolarSmoothLineMarkers = 45,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 雷達圖
??????????????? /// </summary>
??????????????? chChartTypeRadarLine = 34,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 填充雷達圖
??????????????? /// </summary>
??????????????? chChartTypeRadarLineFilled = 36,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造雷達圖
??????????????? /// </summary>
??????????? ????chChartTypeRadarLineMarkers = 35,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 平滑雷達圖
??????????????? /// </summary>
??????????????? chChartTypeRadarSmoothLine = 37,
??????????????? /**/
??????????????? /// <summary>
????????? ??????/// 制造平滑雷達圖
??????????????? /// </summary>
??????????????? chChartTypeRadarSmoothLineMarkers = 38,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 線形散點圖
??????????????? /// </summary>
??????????????? chChartTypeScatterLine = 25,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 填充線形散點圖
??????????????? /// </summary>
??????????????? chChartTypeScatterLineFilled = 26,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造線形散點圖
??????????????? /// </summary>
??????????????? chChartTypeScatterLineMarkers = 24,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造散點圖
??????????????? /// </summary>
??????????????? chChartTypeScatterMarkers = 21,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 平滑散點圖
??????????????? /// </summary>
??????????????? chChartTypeScatterSmoothLine = 23,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造平滑散點圖
??????????????? /// </summary>
??? ????????????chChartTypeScatterSmoothLineMarkers = 22,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 平滑線圖
??????????????? /// </summary>
??????????????? chChartTypeSmoothLine = 12,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造平滑線圖
??????????????? /// </summary>
??????????????? chChartTypeSmoothLineMarkers = 13,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 重疊平滑線圖
??????????????? /// </summary>
??????????????? chChartTypeSmoothLineStacked = 14,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 100%重疊平滑線圖
??????????????? /// </summary>
??????????????? chChartTypeSmoothLineStacked100 = 16,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造100%重疊平滑線圖
??????????????? /// </summary>
??????????????? chChartTypeSmoothLineStacked100Markers = 17,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 制造重疊平滑線圖
??????????????? /// </summary>
??????????????? chChartTypeSmoothLineStackedMarkers = 15,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 股價圖
??????????????? /// </summary>
??????????????? chChartTypeStockHLC = 39,
??????????????? /**/
??????????????? /// <summary>
??????????????? /// 股價圖O型
??????????????? /// </summary>
??????????????? chChartTypeStockOHLC = 40
?
??????????? }
??????????? #endregion
?
??????????? #region 構(gòu)造函數(shù)
??????????? public OWCChart11()
??????????? {
??????????????? //
??????????????? // TODO: 在此處添加構(gòu)造函數(shù)邏輯
??????????????? //
??????????? }
?
??????????? public OWCChart11(string SavePath, string SeriesName, string Title, int ChartType)
??????????? {
??????????????? m_SavePath = SavePath;
??????????????? m_SeriesName = SeriesName;
??????????????? m_Title = Title;
?????????????? ?m_Type = ChartType;
??????????? }
?
??????????? public OWCChart11(string SavePath, string SeriesName, string Title, int ChartType, string AxesXTitle, string AxesYTitle)
??????????? {
??????????????? m_SavePath = SavePath;
??????????????? m_SeriesName = SeriesName;
??????????????? m_Title = Title;
??????????????? m_AxesXTitle = AxesXTitle;
??????????????? m_AxesYTitle = AxesYTitle;
??????????????? m_Type = ChartType;
??????????? }
?
??????????? public OWCChart11(string SavePath, string SeriesName, string Title, int ChartType, string AxesXTitle, string AxesYTitle, int PicWidth, int PicHeight)
??????????? {
??????????????? m_SavePath = SavePath;
??????????????? m_SeriesName = SeriesName;
??????????????? m_Title = Title;
??????? ????????m_AxesXTitle = AxesXTitle;
??????????????? m_AxesYTitle = AxesYTitle;
??????????????? m_PicWidth = PicWidth;
??????????????? m_PicHeight = PicHeight;
??????????????? m_Type = ChartType;
??????????? }
??????????? #endregion
?
??????????? public bool Create()
??????????? {
??????????????? //聲明對象
??????????????? Microsoft.Office.Interop.Owc11.ChartSpace ThisChart = new Microsoft.Office.Interop.Owc11.ChartSpaceClass();
??????????????? Microsoft.Office.Interop.Owc11.ChChart ThisChChart = ThisChart.Charts.Add(0);
??????????????? Microsoft.Office.Interop.Owc11.ChSeries ThisChSeries = ThisChChart.SeriesCollection.Add(0);
?
??????????????? //顯示圖例
??????????????? ThisChChart.HasLegend = true;
?
??????????????? //顯示標題選項
??????????????? ThisChChart.HasTitle = true;
??????????????? ThisChChart.Title.Font.Name = "黑體";
??????????????? ThisChChart.Title.Font.Size = 14;
??????????????? ThisChChart.Title.Caption = m_Title;//from
?
??????????????? //x,y軸說明
??????????????? //x
??? ????????????ThisChChart.Axes[0].HasTitle = true;
??????????????? ThisChChart.Axes[0].Title.Font.Name = "黑體";
??????????????? ThisChChart.Axes[0].Title.Font.Size = 12;
??????????????? ThisChChart.Axes[0].Title.Caption = m_AxesXTitle;
?
??????????????? ThisChChart.Axes[1].HasTitle = true;
??????????????? ThisChChart.Axes[1].Title.Font.Name = "黑體";
??????????????? ThisChChart.Axes[1].Title.Font.Size = 12;
??????????????? ThisChChart.Axes[1].Title.Caption = m_AxesYTitle;
?
??????????????? //圖表類型
??????????????? ThisChChart.Type = (Microsoft.Office.Interop.Owc11.ChartChartTypeEnum)m_Type;
??????????????? //??????????? switch(m_Type)
??????????????? //??????????? {
??????????????? //??????????????? case 0:???
??????????????? //??????????????????? ThisChChart.Type =(Microsoft.Office.Interop.Owc11.ChartChartTypeEnum) m_Type;// Microsoft.Office.Interop.Owc11.ChartChartTypeEnum.chChartTypeColumn3D;//柱狀圖3D
??????????????? //??????????????????? break;
??????????????? //??????????????? case 1:
?????????? ?????//??????????????????? ThisChChart.Type = Microsoft.Office.Interop.Owc11.ChartChartTypeEnum.chChartTypeBar3D;//橫道圖3D
??????????????? //??????????????????? break;
??????????????? //??????????????? case 2:
??????????????? //??????????????????? ThisChChart.Type = Microsoft.Office.Interop.Owc11.ChartChartTypeEnum.chChartTypeSmoothLine;//平滑曲線圖
??????????????? //??????????????????? break;
??????????????? //??????????????? case 3:
??????????????? //????????????? ??????ThisChChart.Type = Microsoft.Office.Interop.Owc11.ChartChartTypeEnum.chChartTypePie;//圓餅圖
??????????????? //???????????????????
??????????????? //
??????????????? //??????????????????? break;
??????????????? //??????????? }
??????????????? //旋轉(zhuǎn)
??? ????????????ThisChChart.Rotation = 360;
??????????????? ThisChChart.Inclination = 10;
??????????????? //背景顏色
??????????????? ThisChChart.PlotArea.Interior.Color = "red";
??????????????? //底座顏色
??????????????? ThisChChart.PlotArea.Floor.Interior.Color = "green";
?
??????????????? //ThisChChart.Overlap = 50;
?
??????????????? //給定series的名字
??????????????? ThisChSeries.SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimSeriesNames, Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral.GetHashCode(), m_SeriesName);
??????????????? //給定分類
??????????????? ThisChSeries.SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimCategories, Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral.GetHashCode(), m_Category);
??????????????? //給定值
??????????????? ThisChSeries.SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimValues, Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral.GetHashCode(), m_Value);
?
??????????????? Microsoft.Office.Interop.Owc11.ChDataLabels dl = ThisChChart.SeriesCollection[0].DataLabelsCollection.Add();
??????????????? dl.HasValue = true;
??????????????? //dl.HasPercentage=true;??
??????????????? //導(dǎo)出圖像文件
??????????????? try
??????????????? {
??????????????????? if (m_FileName == null || m_FileName == "")
??????????????????? {
??????????????????????? m_FileName = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".gif";//生成圖片名稱
??????????????????? }
??????????????????? ThisChart.ExportPicture(m_SavePath + "\\" + m_FileName, "gif", m_PicWidth, m_PicHeight);
??????????????????? return true;
??????????????? }
??????????????? catch (Exception ee)
??????????????? {
??????????????????? return false;
??????????????? }
??????????????? return false;
????????? ??}
?
?
??????? }
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索:z360901061

微信掃一掃加我為好友
QQ號聯(lián)系: 360901061
您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
