[Solved] In excel, add the text name/location in graph

[chili]

i need the prepare the chart including the mentioned the location name of the required format. Its should be prepare the excel sheet. how to include the location name on the chart.

Highly appreciate if you all can provide the answer for that.

 

[Seemanto Saha]

Hello chili,
Thanks for sharing your problem with us. I understand you want to add the Tenure Location names to a chart. Based on the type of chart you require, there are multiple ways to incorporate the Tenure Location names into the chart. Here, I will add a 2-D Column Chart for Total Count values and a Scatter Chart with Smooth Lines and Markers for the Highest Count.

First, I have added a new column named “All Locations”. I used the following formula in Cell E16 and dragged down the Fill Handle icon.​

=TEXTJOIN(",",TRUE,B3:E3)

Here, the TEXTJOIN function joins all the locations of January to April with a Comma (,) in one cell so that we can apply it as a Data Label.

After that, select the range A15:B25 >> go to the Insert tab >> click the Column or Bar Chart drop-down >> select the Clustered Column chart option.​

The following chart will appear.

Select any column in the Highest series >> right-click on your mouse >> select Change Series Chart Type from the right-click menu.​

In the Change Chart Type pop-up window, click the drop-down of the Chart Type option for the Highest series >> scroll down and select the Scatter with Smooth Lines and Markers chart option >> click the OK button.​

Now, select the chart >> click the Plus (+) button >> hover the mouse pointer on the right side of the Axes option >> disable the Secondary Horizontal option >> disable the Chart Title option >> enable the Data Labels option >> disable the Gridlines option.​

Next, double-click on any of the Highest series Data Labels, and in the Format Data Labels pane, enable the Value From Cells option.​

Set the Select Data Label Range to range D1625 and click the OK button.

Disable the Y Values option and select the Above option for Label Position.

Similarly, double-click on any of the Data Labels of the Total Count series, and in the Format Data Labels pane, enable the Value From Cells option.​

Set the Select Data Label Range to range E16:E25 and click the OK button.

Disable the Y Values option and select the Center option for Label Position.

Here is the final view of the chart. As you can see, all the required locations are added to the subsequent Columns or Markers as Data Labels.​

I hope this solution will help you get an understanding of how we can add any type of Data Labels to a chart.

Let us know your feedback. The workbook used for the solution of this problem is attached below.
​

Regards,
Seemanto Saha
ExcelDemy