One way to do this is by manually adding data labels to the chart within excel, but we're going to achieve the same result in a single line of code. Of course you can change these settings, but it isn’t obvious how to use custom text for your labels. To add or move data labels in a chart, you can do as below steps: Now if you add additional data and update the chart, the data labels will update automatically and so you don’t need to worry about the recoloring or connecting cells etc. This will select “all” data labels.Īdd axis label to chart in excel 2013. Doing so will cause a group of tabs titled chart tools to appear in excel’s toolbar with the design, layout and format tabs residing within it. Excel displays a number of options that control where your data labels are positioned. Activate the chart by clicking on it, if necessary. Data labels are the values in the chart, which make the chart easy to understand.
Haslegendkey = true // set the display legend keyĬslabel. Get the first worksheet and the first chart in itĬhartSerie chartSeries = chart.Series ĬhartDataLabels cslabel = Ĭslabel. Workbook.LoadFromFile("AddDataLable.xlsx") Here, take the data annotation added in the above code as an example to modify. Workbook.SaveToFile("AddDataLable.xlsx") //Customize datalabel with data from other cells in the document Get the first workbook and the first chart in it
0 kommentar(er)
