I have a simple chart in Google Sheets. Currently, the data labels are just numbers. I want to append a % sign infront of each value. How can I do so?
You can use a VBA macro for this:
Sub AppendPercent() Dim objCell as Range For Each objCell in Selection If objCell.Value <> "" Then objCell.Value = objCell.Value & "%" Next End Sub
Now before running this macro, select all the cells where percent is needed to be appended. Then click Alt+F1 to open Microsoft Visual Basic for Applications and then in Insert > Module paste the code. Then hit F5 to run macro.