多语言展示
当前在线:780今日阅读:75今日分享:44

C# 创建PPT堆积柱形图

堆积柱形图显示单个项目与整体之间的关系,它比较各个类别的每个数值所占总数值的大小,以二维垂直堆积矩形显示数值。当有多个数据系列并且希望强调总数值时,可以使用堆积柱形图。本文将介绍如何使用C#创建PPT堆积柱形图。
工具/原料
1

Spire.Presentation for .NET

2

Visual Studio

方法/步骤
1

下载并安装Spire.Presentation for .NET, 并将Spire.Presentation.dll文件应用到项目中。

2

将代码放入Visual Studio中:using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using Spire.Presentation;using System.Drawing;using Spire.Presentation.Charts;namespace Columnstacked_Chart{        class Program            {                     static void Main(string[] args)                          {                               //创建一个PowerPoint文档                                Presentation presentation = new Presentation();                               //插入堆积柱形图                                RectangleF rect = new RectangleF(0, 50, 650, 500);                                 IChart chart = presentation.Slides[0].Shapes.AppendChart(ChartType.ColumnStacked, rect, false);                                //将数据写入图表数据表                                 chart.ChartData[0, 1].Text = 'T恤';                                chart.ChartData[0, 2].Text = '衬衫';                                 chart.ChartData[0, 3].Text = '毛衣';                                 chart.ChartData[0, 4].Text = '针织衫';                                 chart.ChartData[0, 5].Text = '外套';                                 chart.ChartData[0, 6].Text = '风衣';                                 chart.ChartData[0, 7].Text = '大衣';                                 chart.ChartData[0, 8].Text = '棉衣';                                chart.ChartData[0, 9].Text = '西装';                                 //输入数据                                chart.ChartData[1, 0].Text = '周一';                                 chart.ChartData[6, 0].Text = '周二';                                 chart.ChartData[11, 0].Text = '周三';                                 chart.ChartData[16, 0].Text = '周四';                                 chart.ChartData[21, 0].Text = '周五';                                chart.ChartData[26, 0].Text = '周六';                                 chart.ChartData[31, 0].Text = '周七';                                 //输入各系列的数值                                chart.ChartData[1, 1].Value = 3200;                                 chart.ChartData[6, 1].Value = 3342;                                 chart.ChartData[11, 1].Value = 7301;                                chart.ChartData[16, 1].Value = 8334;                                chart.ChartData[21, 1].Value = 9390;                                 chart.ChartData[26, 1].Value = 2330;                                 chart.ChartData[31, 1].Value = 7320;                                  //第二系列的数值                                 chart.ChartData[2, 2].Value = 8120;                                 chart.ChartData[7, 2].Value = 2132;                                 chart.ChartData[12, 2].Value = 7101;                                chart.ChartData[17, 2].Value = 6134;                                 chart.ChartData[22, 2].Value = 590;                                chart.ChartData[27, 2].Value = 7230;                                 chart.ChartData[32, 2].Value = 7210;                                 //第三系列的数值                                 chart.ChartData[2, 3].Value = 3220;                                 chart.ChartData[7, 3].Value = 7182;                                 chart.ChartData[12, 3].Value = 2191;                                chart.ChartData[17, 3].Value = 7234;                                 chart.ChartData[22, 3].Value = 5290;                                 chart.ChartData[27, 3].Value = 3630;                                 chart.ChartData[32, 3].Value = 8310;                                  //第四系列的数值                                  chart.ChartData[2, 4].Value = 7150;                                  chart.ChartData[7, 4].Value = 5232;                                 chart.ChartData[12, 4].Value = 7201;                                  chart.ChartData[17, 4].Value = 6154;                                  chart.ChartData[22, 4].Value = 8190;                                  chart.ChartData[27, 4].Value = 5330;                                  chart.ChartData[32, 4].Value = 8410;                                  //第五系列的数值                                  chart.ChartData[3, 5].Value = 4862;                                  chart.ChartData[8, 5].Value = 1018;                                  chart.ChartData[13, 5].Value = 1964;                                  chart.ChartData[18, 5].Value = 1026;                                  chart.ChartData[23, 5].Value = 1679;                                 chart.ChartData[28, 5].Value = 1600;                                 chart.ChartData[33, 5].Value = 1570;                                  //第六系列的数值                                  chart.ChartData[4, 6].Value = 1620;                                  chart.ChartData[9, 6].Value = 732;                                  chart.ChartData[14, 6].Value = 2701;                                  chart.ChartData[19, 6].Value = 3734;                                  chart.ChartData[24, 6].Value = 1090;                                  chart.ChartData[29, 6].Value = 1130;                                   chart.ChartData[34, 6].Value = 1120;                                 //第七系列的数值                                  chart.ChartData[4, 7].Value = 5120;                                  chart.ChartData[9, 7].Value = 7132;                                 chart.ChartData[14, 7].Value = 9101;                                  chart.ChartData[19, 7].Value = 3134;                                  chart.ChartData[24, 7].Value = 5290;                                  chart.ChartData[29, 7].Value = 8230;                                  chart.ChartData[34, 7].Value = 7220;                                   //第八系列的数值                                   chart.ChartData[4, 8].Value = 7560;                                   chart.ChartData[9, 8].Value = 3672;                                   chart.ChartData[14, 8].Value = 5671;                                   chart.ChartData[19, 8].Value = 4574;                                   chart.ChartData[24, 8].Value = 8190;                                   chart.ChartData[29, 8].Value = 6130;                                   chart.ChartData[34, 8].Value = 7110;                                   //第九系列的数值                                   chart.ChartData[4, 9].Value = 2562;                                   chart.ChartData[9, 9].Value = 1782;                                   chart.ChartData[14, 9].Value = 2891;                                  chart.ChartData[19, 9].Value = 3684;                                   chart.ChartData[24, 9].Value = 6109;                                   chart.ChartData[29, 9].Value = 7110;                                   chart.ChartData[34, 9].Value = 8120;                                   //设置分类标签                           chart.Categories.CategoryLabels = chart.ChartData['A1', 'A35'];                                  //设置图例位置                                chart.ChartLegend.Position = ChartLegendPositionType.Top;                                       //设置系列标签                                chart.Series.SeriesLabel = chart.ChartData['B1', 'J1'];                                //为各个系列赋值                               chart.Series[0].Values = chart.ChartData['B2', 'B35'];                               chart.Series[1].Values = chart.ChartData['C2', 'C35'];                              chart.Series[2].Values = chart.ChartData['D2', 'D35'];                                chart.Series[3].Values = chart.ChartData['E2', 'E35'];                              chart.Series[4].Values = chart.ChartData['F2', 'F35'];                              chart.Series[5].Values = chart.ChartData['G2', 'G35'];                                chart.Series[6].Values = chart.ChartData['H2', 'H35'];                                chart.Series[7].Values = chart.ChartData['I2', 'I35'];                               chart.Series[8].Values = chart.ChartData['J2', 'J35'];                               //保存文档                          presentation.SaveToFile('堆积柱形图.pptx', FileFormat.Pptx2007);                 }         }}

3

调试并运行代码后,生成的文档如下图所示:

推荐信息