Indication in Stacked chart for MIN, MAX (stuck he

2019-08-28 07:04发布

问题:

Stuck in trying to adjust an arrow (sort of) inside an Excel chart.

I have a column chart with series of data. I want to point out minimum, maximum, and average value from the chart. What i was planning is, to mark it by an arrow.

Is it possible via C#?

For the below chart, I want to indicate MIN & MAX, like the ones I have drawn.

I started by getting the charts by this:

Excel.Application app = new Excel.Application();
Excel.Workbook book;
Excel.Worksheet sheet;
Excel.ChartObject chartObj;
Excel.Chart chart;

book = app.Workbooks.Open(@"Path to workbook");//Open the work book
sheet = book.Sheets["sheet name"];//Select the sheet the chart is on
chartObj = sheet.ChartObjects("Chart name");//Select the ChartObject
chart = chartObj.Chart; //Select the Chart from the ChartObjec

Findings:

I could not even find a general way - to represent min,max in a stacked chart.