Data label Google spreadsheet Column chart

3
votes

I have created a column chart in Google spreadsheet, but it is not showing data label explicitly.

screenshot

I need data value to be shown on top of each bar of column chart. Currently, that is showing only as tool tip, but I require it to be always visible.

I have not used any script just created it directly, please provide some way either by script/direct to implement data labels. only direct / apps script but no java script as I only need to view it on my spreadsheet.

here is link of sheet: https://docs.google.com/spreadsheets/d/1a95DrTeLA52Xmycq3IUlWgfqASQWJQla7xEXx5-KWGE/edit?usp=sharing

2
google-apps-scriptgoogle-sheetsgoogle-spreadsheet-api
Show your code. There are several ways to implement charts. – Mogsdad
@Mogsdad I have not used any script just created it directly, please provide some way either by script/direct to implement data labels. only direct / apps script but no java script as I only need to view it on my spreadsheet. – Himanshu Tiwari
You're going to have to explain your question better, to show exactly what you mean. Pictures would help immensely. At this time, it's not clear what your problem is. (For example - have you tried right-clicking on the chart, and setting the Axis titles?) – Mogsdad
@Mogsdad I need data value to be shown on top of each bar of column chart. Axix title is not solving it. view image as below link facebook.com/… – Himanshu Tiwari
I've updated your question with the additional info you provided. Good luck! – Mogsdad

2 Answers

1
votes

You may have found the solution by now but just in case it might be helpful to others, here's my response.

Your sharing of sheet was useful in helping you with your question. Here are the steps to get the values for the data labels on the top of your columns.

  • Right click on the chart.
  • Click on Advanced Edit. (This will open a new window named "Chart Editor")
  • Click on "Customization" tab.
  • Drag the bar and keep going down until you see "Data Labels" with a drop down below it.
  • Click on the drop down. (This will open a list of options)
  • Choose "value" from this list of options.
  • Click "Update" and you'll see the change in your graph.

Let me know if you have any questions.

-3
votes

I figured out a solution. If you create a pivot table and graph that data, the values will show.