Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

remove/hide legend chart excel

hi i have this following code

 private static void exportChart()
    {
        Excel.Range chartRange;
        Excel.ChartObjects xlCharts = (Excel.ChartObjects)oWorkSheet.ChartObjects(Type.Missing);
        Excel.ChartObject myChart = (Excel.ChartObject)xlCharts.Add(10, 80, 300, 150);
        Excel.Chart chartPage = myChart.Chart;

        chartRange = oWorkSheet.get_Range("E5", "F13");
        chartPage.SetSourceData(chartRange, misValue);
        chartPage.ChartType = Excel.XlChartType.xlColumnClustered;

        Excel.Range chartPlacementRange = oWorkSheet.get_Range("F11", "F11");
        myChart.Left = (float)((double)chartPlacementRange.Top);
        myChart.Top = (float)((double)chartPlacementRange.Left);
    }

i try to remove/hide legend in chart, i already try code from this link

chart.Legend.LegendEnteries(chart.Legend.LegendEntries().Count).Delete();

so in my case it would be like this

chartPage.Legend.LegendEntries(chartPage.Legend.LegendEntries().Count).Delete();

but unfortunatelly this is as far as i can..... (after type LegendEntries twice it's not available .count or .delete)

chartPage.Legend.LegendEntries(chartPage.Legend.LegendEntries());

how to do it correctly?

like image 720
Neversaysblack Avatar asked May 23 '26 20:05

Neversaysblack


1 Answers

You already figured it out in your comment, but I think it's better to consider this as a answer. So there is goes:

chartPage.Legend.Clear();
like image 121
Daniel Bonetti Avatar answered May 25 '26 10:05

Daniel Bonetti



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!