CODEWITHSUNDEEP
chartsgoogle-visualization
Nick
Nick

Reputation: 21

Add column data value labels in Google Drive Spreadsheet chart

Is there an (easy) way to add data-value labels to the columns of a Google Drive Spreadsheet column chart? Either fixed or mouse-over?

I have the charts already made, and would not like to have to define them again. So I'm basically looking to alter the default behaviour of the existing charts.

The spreadsheet and charts are not (yet) for publishing, only for sharing directly.

Nick

Upvotes: 0

Views: 3291

Answers (1)

Wicket
Wicket

Reputation: 38130

Google Sheets embedded charts have text annotations. To use them for values, you could use TEXT() function. I.E. assume that you have a two column chart, then add a third column for annotations. Add the following formula

=TEXT(A2,"0")

then fill down as necessary.

Example

References
Adding annotations to a chart - Docs Editors Help

Upvotes: 1

Related Questions