CODEWITHSUNDEEP
google-sheets
bwakabats
bwakabats

Reputation: 703

Google Sheet Histogram Chart x-axis and y-axis have different format

I have a single column of dates in a google sheet (UK format):

Date
----
11/06/2021
18/05/2021
18/05/2021
07/06/2021
07/06/2021
08/06/2021
19/05/2021
19/05/2021
19/05/2021
19/05/2021
19/05/2021
28/05/2021
03/06/2021
17/05/2021
17/05/2021
17/05/2021
25/05/2021
11/05/2021
11/05/2021

If I create a Histgram chart, I get this result: Google Sheets Histgram Chart

My issue is that the x-axis is showing the date range but formatted as a number and the y-axis is showing the frequency but formatted as a date.

How can I change the format?

This is an example of my problem: https://docs.google.com/spreadsheets/d/11dHU31RG-ykJrOypMid6Suw8xsvnRD4CByJkM5BUptQ/edit?usp=sharing

Upvotes: 0

Views: 1249

Answers (1)

iansedano
iansedano

Reputation: 6481

Unfortunately, the only data type that the Histogram supports is plain numbers

Officially its not supported. Source

Though it seems that its actually picking up the right way to organize it, the formatting of the series is not working.

When I tested it, I just did a bar chart which worked, but for histograms, I got the same result as you.

There is a feature request in the underlying visualization library here:

https://github.com/google/google-visualization-issues/issues/1457

More info here:

Upvotes: 1

Related Questions