我正在尝试更改 excel 2013 中图表的样式,但它只更改颜色:
Range chartRange;
ChartObjects wsCharts = (ChartObjects)workSheet.ChartObjects(Type.Missing);
ChartObject myChart = (ChartObject)wsCharts.Add(0, 0, 900, 500);
Chart workChart = myChart.Chart;
chartRange = workSheet.get_Range("A1", "D12");
workChart.SetSourceData(chartRange, Type.Missing);
workChart.ChartType = XlChartType.xlColumnClustered;
now the chart looks like this:
![original](https://i.stack.imgur.com/6ebDk.png)
and then workChart.ChartStyle = 8;
changes the bar's color to:
![new](https://i.stack.imgur.com/BXiEF.png)
instead of the chart's style to:
![enter image description here](https://i.stack.imgur.com/NZzNm.png)
我也尝试过玩ChartWizard
的方法和其他属性Chart
但到目前为止还没有运气。
Try
workChart.ChartStyle = 209;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)