Get number format from source data for individual values in Google Sheets charts
In Google Sheets it is possible for data labels in a chart to reflect the number formats for individual scale points? Even if its only possible via the Google Sheets REST API that would be fine.
Currently it is possible in a chart to set the number format for data labels to "From source data", and data labels in the chart do successfully reflect that format.
But my problem is that the chart reads the custom number format only from the first cell in the source data, and then applies it to every data label in the series. Example
In the image below, the chart successfully reads the custom number format from the first value...
But what I want to get is like the mockedup image below:
You can work around the number format limitation with a helper column and some string manipulation. Enter the formula =text(C4,"0%") in D4 and copy it down the column for each value in column C. In D8 replace the formula with =char(9650)&" "&text(C8,"0%") and in D11 replace the formula with =char(9660)&" "&text(C11,"0%").
Finally, in the chart options, change the source range to include column D, then under 'Series' click the three dots next to 'Qty', then on 'Add labels' and finally select the D4:D15 range.
- How to Show/Hide rows in google sheets using a script?
- Trying to figure out why my GoogleSheets Date formula is not working
- Google Sheets Row Number of last row in a defined table
- How can I use INDEX and MATCH along with conditions to filter data into different tables?
- Google Sheets formula to remove all punctuation excluding period (.)
- Formula to find missing serial numbers
- Google Sheet Vlookup Multiple Criteria
- Copy Data from one column and past at the end of another column
- Query formula not grouping properly
- Comparing text fields that contain dates in Google Sheets
- Signature Pad (Canvas) to Google Sheets
- regexreplace multiple columns for football data
- I want to use a macro to check a value in a sheet and return one of two values
- How can I remove consecutive duplicates from a range in Google Sheets?
- Using FILTER with multiple conditions on Google Sheet
- How to union ranges in google spreadsheets
- Google Sheets Dynamic Dropdown List Dependent with multiple rows
- Formula for filtering list based off of key with multiple criteria in Google Sheets
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- How to use Apps script to move a lot of data rows at same time to different spreadsheet automatically base on time
- How to ignore empty rows when submitting to database
- Custom Menus Google Apps Script
- Google Sheets Index Sidebar of all tabs - add search functionality
- How do I compare new IDs with a column of existing IDs and allowcate a timestamp if two IDs match on Google Sheets?
- Google script Display array with rows of different sizes
- How to Delete Today's Google Calendar Entries in Google Apps Script
- List rows in array when the cell contain number in the string
- ImportXML XPath issue using Google Sheets on a simple web scraping query
- Google Sheets Macro Script to expand column group based on cell value
- Return index of cell that contains match on two strings