When selecting the color for a line in a chart, I see 80 choices of colors. Is there a way to add new colors or set a color using RGB, HSV or HTML colors?
Google-sheets – How to choose custom colors for Google Spreadsheet charts
google sheetsgoogle-sheets-charts
Related Solutions
Currently there are 8 grayscale options for column colors, ranging from black to white. I suppose the distinguishability of those grays will depend upon print quality. I don't see any way to specify patterns that would be more clearly visible in black and white.
This issue has been already patched and charts can be nowadays (17.01.2019) moved around and resized with millimetre precision across the whole spreadsheet. Maximum precision of placing can be achieved by holding SHIFT key with arrow keys.
Related Topic
- Google-sheets – Downloading charts from Google Sheets in high resolution
- Google-sheets – Creating a chart with independently indexed series
- Google-sheets – How to preserve colors of each series from changing when inserting new data in Chart Editor
- Google-sheets – Unable to change Google Sheets data point format without changing other data points
- Google-sheets – Possible to add a third color to a ‘bar’ sparkline
Best Answer
Not natively, however here is a workaround:
You can create a chart with the custom colors using Microsoft Excel, and then save this document and import it into Google Drive. If you then open the xlsx file with Google Sheets it will automatically convert the formats, and keep the custom colors you added.
This obviously limits the complexity of the charts and documents this is useful for, but I've found it helpful for creating a 'template' google sheet with the charts formatted the way I want.