Possible Bug: Google Sheet's Charts changing colors randomly

1,338 views
Skip to first unread message

LFer

unread,
Jul 22, 2019, 8:21:52 PM7/22/19
to Google Visualization API
Hello, I want to report that google charts are not working well. The colors are switching automatically to the predefined google colors, is anyone else experiencing this?

Eva Chen

unread,
Jul 22, 2019, 9:05:07 PM7/22/19
to Google Visualization API
I've been experiencing this as well, and also if I change one thing in the chart (e.g., color of one column), the next edit I make reverts the previous edit to the default.

Mark Loring

unread,
Jul 23, 2019, 10:22:03 AM7/23/19
to Google Visualization API
Yes, I have too. It just started. What changed last night?


On Monday, July 22, 2019 at 5:21:52 PM UTC-7, LFer wrote:

Mike Higgins

unread,
Jul 23, 2019, 11:25:45 AM7/23/19
to google-visua...@googlegroups.com
I noticed a google update has recently occured (the palat color selectors for Sheets are now round instead of square) so, pretty sure everything went to hell after that.
Multiple problems, including having to mouse over published charts to make them visible, unable to edit series without re-formatting all data points, data points disappear when new ones are added, it's just horrible...major Google screwup.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/a653761f-be9d-4371-9794-f34a6a7c3499%40googlegroups.com.

Ronald Reyes

unread,
Jul 24, 2019, 12:16:30 PM7/24/19
to Google Visualization API
Experiencing the same. Adjusting a stacked column chart colors changes other parts of the chart. The second color automatically changes and horizontal axis text changes also change the colors on bars. 


On Monday, July 22, 2019 at 5:21:52 PM UTC-7, LFer wrote:

Junior Mendoza

unread,
Jul 24, 2019, 12:33:22 PM7/24/19
to Google Visualization API
Same! It has shown one color in the edit pane, but the graph is an entirely different color. 

Mike Higgins

unread,
Jul 24, 2019, 12:36:26 PM7/24/19
to google-visua...@googlegroups.com
I spoke with Google support on the phone this morning, and after running me through several different steps was never able to resolve the problem. She told me to wait a few days to see if the problem corrected itself. If not, I'm supposed to email her back. Recommend everyone else who is experiencing these problems to do the same so Google can get on this and fix it. I'm not real confident that it is going to fix itself.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/b5510aa9-005d-4eb5-b317-c0e210bc4dba%40googlegroups.com.

Mike Higgins

unread,
Jul 24, 2019, 12:37:28 PM7/24/19
to google-visua...@googlegroups.com
I spoke with Google support on the phone this morning, and after running me through several different steps was never able to resolve the problem. She told me to wait a few days to see if the problem corrected itself. If not, I'm supposed to email her back. Recommend everyone else who is experiencing these problems to do the same so Google can get on this and fix it. I'm not real confident that it is going to fix itself.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/3236ff95-aecf-4ecb-84fd-a9f83304b1fb%40googlegroups.com.

w A

unread,
Jul 25, 2019, 12:48:12 AM7/25/19
to Google Visualization API
Same issue here. 


On Monday, July 22, 2019 at 8:21:52 PM UTC-4, LFer wrote:

Etsy H

unread,
Jul 25, 2019, 11:55:33 AM7/25/19
to Google Visualization API
Same issue here and it needs to be fixed ASAP!  We are no longer able to have two colors in a graph and there is no longer a way to have multiple data points with custom formatting.  This is a HUGE issue.  How do we get attention on this other than posting here??

ARGH!!!!!!!


On Monday, July 22, 2019 at 5:21:52 PM UTC-7, LFer wrote:

Mike Higgins

unread,
Jul 25, 2019, 12:11:18 PM7/25/19
to google-visua...@googlegroups.com
I spoke with Google on the phone yesterday. After having me try several different things she told me to just wait one or two days to see if it would fix itself. Very disappointing.
And it's not just a problem with charts. I also cannot sum across sheets anymore.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/0b7dc397-e886-41bc-ab3a-4ae2628b9bf9%40googlegroups.com.

Diane Berthold

unread,
Jul 25, 2019, 6:15:41 PM7/25/19
to Google Visualization API
Hey Mike, got a # for them handy? This is driving me crazy and I have multiple presentations due!


On Wednesday, July 24, 2019 at 10:36:26 AM UTC-6, Mike Higgins wrote:
I spoke with Google support on the phone this morning, and after running me through several different steps was never able to resolve the problem. She told me to wait a few days to see if the problem corrected itself. If not, I'm supposed to email her back. Recommend everyone else who is experiencing these problems to do the same so Google can get on this and fix it. I'm not real confident that it is going to fix itself.

On Wed, Jul 24, 2019, 12:33 PM Junior Mendoza <junior...@tulip.co> wrote:
Same! It has shown one color in the edit pane, but the graph is an entirely different color. 

On Monday, July 22, 2019 at 8:21:52 PM UTC-4, LFer wrote:
Hello, I want to report that google charts are not working well. The colors are switching automatically to the predefined google colors, is anyone else experiencing this?

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.

Mike Higgins

unread,
Jul 25, 2019, 6:25:27 PM7/25/19
to google-visua...@googlegroups.com
I think I just searched for Google Sheets help and they give you the option of speaking with someone - you click on that and then they call you.
I certainly share your frustration though I'm sure in your case it's double since you have a presentation. By the way, are you able to "sum across sheets" - the value of a cell from one sheet appearing in the cell of another sheet: =sheet name!cell name ?
I lost that functionality as well.

On Thu, Jul 25, 2019, 6:15 PM Diane Berthold <di...@powersellingpros.com> wrote:
Hey Mike, got a # for them handy? This is driving me crazy and I have multiple presentations due!

On Wednesday, July 24, 2019 at 10:36:26 AM UTC-6, Mike Higgins wrote:
I spoke with Google support on the phone this morning, and after running me through several different steps was never able to resolve the problem. She told me to wait a few days to see if the problem corrected itself. If not, I'm supposed to email her back. Recommend everyone else who is experiencing these problems to do the same so Google can get on this and fix it. I'm not real confident that it is going to fix itself.

On Wed, Jul 24, 2019, 12:33 PM Junior Mendoza <junior...@tulip.co> wrote:
Same! It has shown one color in the edit pane, but the graph is an entirely different color. 

On Monday, July 22, 2019 at 8:21:52 PM UTC-4, LFer wrote:
Hello, I want to report that google charts are not working well. The colors are switching automatically to the predefined google colors, is anyone else experiencing this?

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/e720d1e7-6fd6-4484-a2ea-3f060c14d1fa%40googlegroups.com.

Diane Berthold

unread,
Jul 26, 2019, 10:28:22 AM7/26/19
to google-visua...@googlegroups.com
Nope, I can run sums across sheets either. To transition this all into Excel is going to be so tedious. Ugh. I am not a fan of Google right now. 

Gratefully,

Diane Berthold
Director of Monitoring
Power Selling Pros



Mike Higgins

unread,
Jul 26, 2019, 10:56:16 AM7/26/19
to google-visua...@googlegroups.com
Yeah, you're preaching to the choir now. One thing that Google help had me do was sign out of Google to see if that would work - which it didn't, but after thinking about it I realized I didn't sign out of Google on all my devices. I wonder if that would make a difference. I was going to try and do that tonight.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/aa3b68f5-1a36-aaf3-9521-ae9573b3f1eb%40mixmax.com.

Diane Berthold

unread,
Jul 26, 2019, 1:38:39 PM7/26/19
to google-visua...@googlegroups.com
Let me know if you have any success with that. I have multiple google accounts that I'm toggling between on multiple devices, and some of the google accounts are shared with people around the world. It would take a concerted effort to make sure everyone is out at the same time. 

Gratefully,

Diane Berthold
Director of Monitoring
Power Selling Pros



Mike Higgins

unread,
Jul 28, 2019, 10:04:32 AM7/28/19
to google-visua...@googlegroups.com

Hi Mike,

Thank you for contacting Google Support. I understand that you are having issues with Google Sheets.  

You can quickly calculate the sum, average, and count in Google Sheets.

See the sum & average  

I hope this information helps. Feel free to reply to this email to get back in touch with me.We are available 24/7 to assist you.

Thanks,
Jon
The Google One team

Google One Android app   |   one.google.com   |   Google One Help Center

© Google LLC, 1600 Amphitheatre Parkway, Mountain View, CA 94043

Mike Higgins <mikehig...@gmail.com>

9:57 AM (4 minutes ago)
to googleone-support
Google Support's (GS) continued attempts to mollify its customers by providing "how to" links instead of addressing the customers' specific complaints that GOOGLE SHEETS NO LONGER WORKS only serves to further aggravate said customers.

The fact that the GS members I have spoken to do not even have a Sheets program to work with so they can see for themselves the MANY malfunctions that the Sheets program is now saddled with - nor do they apparently have any experience with Google Sheets at all - is absolutely infuriating.

It is painfully obvious that GS is nothing more than a hand-holding operation that lacks any expertise or knowledge to understand program malfunctions, or any power to get them repaired. It is just as obvious that Google has not only no intention of making this MAJOR MALFUNCTION a priority, they won't even admit the problem exists - despite countless forum members' posts describing the exact same issues.

It's ironic that it's the GS experience, not the Sheets problem, that has tainted everything Google for me.
I'm thinking nothing Google is the way to go.

One thing's for sure, GS is a complete FAIL.

Sincerely!


To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/1417edca-ef39-e361-3835-58031acd63f4%40mixmax.com.

Diane Berthold

unread,
Jul 28, 2019, 12:50:09 PM7/28/19
to google-visua...@googlegroups.com
I am laughing my ass off at their response. What the actual? Haha, Mike thank you for carrying this torch. How can they not even notice the impact this has had?? Just wow.  

--
Please excuse (or enjoy) my brevity. I’m sending this from my phone.

Etsy Heidi

unread,
Jul 28, 2019, 5:13:25 PM7/28/19
to google-visua...@googlegroups.com
ATTENTION Google.  You have somehow broken Google Spreadsheets in numerous ways and we need to know when it will be fixed.  We have presentations for customers that are now not able to be provided because of the graph issue (and I am sure more).  The functionality worked fine a week + ago and no longer does.  When are you fixing???????

Please respond that you even see this message as we have no idea if we are being heard.

The thread has all the details.  

Please help1!!


Mark Loring

unread,
Jul 30, 2019, 8:53:30 AM7/30/19
to Google Visualization API
Got a message that Google has Sheets working properly now. I tried it and the problem I had is now resolved.


On Monday, July 22, 2019 at 5:21:52 PM UTC-7, LFer wrote:

Junior Mendoza

unread,
Jul 30, 2019, 9:15:11 AM7/30/19
to Google Visualization API
The problem is fixed for me as well but a colleague who did not have this problem yesterday is now having this problem today. Something is still off. 


Junior Mendoza
Finance, Tulip
m: 530.318.1553
a: 561 Windsor St. B204, Somerville, MA 02143
w: tulip.co e: junior....@tulip.co
--

You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.

Diane Berthold

unread,
Jul 30, 2019, 10:23:02 AM7/30/19
to google-visua...@googlegroups.com
Hooray! My charts are fixed! Thank you everyone who helped. And thank you Google for doing the right thing. :)

Gratefully,

Diane Berthold
Director of Monitoring
Power Selling Pros

To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/0bb81b60-afa9-43d5-9194-b78e5dc4b9fa%40Spark.
Reply all
Reply to author
Forward
0 new messages