No one had this issue I guess:(
On Thursday, 30 August 2018 17:06:49 UTC+1, Minas Miroglu wrote:
>
> Hello there,
>
> I am trying to use Google Sheets API but there one thing making me crazy:(
> Wonder if anyone has a better (or at least a) solution.
>
> I am generating Pie charts. Works perfectly but I want to be able to
> change the colours, do not want to use the default red and blue colours.
> I could not find any parameters to set the Pie Chart colours. So I came up
> with a great idea...:D
>
> I created a source sheet, manually generated a Pie chart with the colours
> I wanted. Then once I create a sheet with data I was copying the chart from
> the source.
> Worked like a charm. I know this is not the best way but... it solved my
> problem.
>
> But then I realised something, the chart title was the same from the
> source title:D Then I decided to create an update request (which is below)
> and then got mad because once I run this title update it literally dumps
> the colours I used in my source chart. I really do not understand why we do
> not get to set colours on Pie chart only...
>
> Does anyone have a solution to this issue? A walk around maybe?
>
> update_chart_title = [{
> "updateChartSpec": {
> "chartId": chart_id,
> "spec": {
> "title": "New Chart Title",
> "pieChart": {
> "domain": {
> "sourceRange": {
> "sources": [
> {
> "sheetId": sheet_id,
> "startRowIndex": 0,
> "endRowIndex": 2,
> "startColumnIndex": 1,
> "endColumnIndex": 2,
> }
> ]
> }
> },
> "series": {
> "sourceRange": {
> "sources": [
> {
> "sheetId": sheet_id,
> "startRowIndex": 0,
> "endRowIndex": 7,
> "startColumnIndex": 2,
> "endColumnIndex": 3
> }
> ]
> }
> },
> }
> },
> }
> }]
> body = {
> 'requests': update_chart_title
> }
> getService.sheets.spreadsheets().batchUpdate(
> spreadsheetId=sheet,
> body=body).execute()
>
>
>
> Thank you!
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
