在c#中使用Microsoft.Office.Interop.Excel的折线图。 [英] Line Chart using Microsoft.Office.Interop.Excel in c#.
问题描述
我有三列 -
1。月份
2。生产
3。返回单位
我想在X轴上绘制月份,在Y轴上绘制其他两个。
I want to plot Month in X Axis and other two on Y axis.
我想要生产和退货单位的折线图。
I want line chart for Production and Returned Units.
那么,告诉我如何设置系列以及x和y轴值?
So, tell me how to set series as well as x and y axis values?
问候,
Swapnil
推荐答案
这很简单......按照以下步骤操作
It simple... follow the steps below
1。创建图表。
Excel.ChartObjects ChartObjects =(Excel.ChartObjects)excelSheet.ChartObjects();
Excel.ChartObjects ChartObjects = (Excel.ChartObjects)excelSheet.ChartObjects();
Excel.ChartObject chartObject = ChartObjects.Add( 40,1000,700,350);
Excel.ChartObject chartObject = ChartObjects.Add(40, 1000, 700, 350);
chartObject.Chart.ChartType = Excel.XlChartType.xlLineMarkers;
       chartObject.Chart.HasTitle = true;
chartObject.Chart.ChartType = Excel.XlChartType.xlLineMarkers;
chartObject.Chart.HasTitle = true;
2。确定x轴的范围
Excel.Range xValRange = excelSheet.Range [" A1"," A5"]
Excel.Range xValRange = excelSheet.Range["A1","A5"]
3 。获取seriescollection
3. Get the seriescollection
Excel.SeriesCollection oSeriesCollection =(Excel.SeriesCollection)chartObject.Chart.SeriesCollection();
Excel.SeriesCollection oSeriesCollection = (Excel.SeriesCollection)chartObject.Chart.SeriesCollection();
然后你可以分配你想要的系列,
then you can assign as much as series you want,
for(int i = 0; i< serieses.Count; i ++)
{
for (int i = 0; i < serieses.Count; i++)
{
Excel.Series oSeries = oSeriesCollection.NewSeries();
Excel.Series oSeries = oSeriesCollection.NewSeries();
oSeries.Values = excelSheet.Range [" B1"," ; B5"];
oSeries.Values = excelSheet.Range["B1","B5"];
}
希望有帮助请告诉我你的意思能够解决目的......
Hope it helps please let me know if you are able to solve the purpose...
这篇关于在c#中使用Microsoft.Office.Interop.Excel的折线图。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!