Bar chart display request

[gila]

I got some feedback from a client yesterday that the bar chart’s y axis display can be a bit confusing.

I have set up a form with a list of questions that clients can respond to with a value from 1-5 (chosen from an option set).

The y axis on the bar chart that displays the user’s responses shows values that actually exceed the maximum number that users can select in the form question.

As you can see in the first screenshot below, the y axis shows a maximum value of 5.4, even though the user can only select 1-5.

In the second screenshot, the y axis shows a maximum value of 4.2, rather than 5.

It would be great if the y axis showed the real maximum value if the user is choosing from an option set of numeric values.

In other circumstances where they are just inputting their own numeric value, and there is no defined upper or lower limit, then it could show whatever the highest value the user input was.

Hope this makes sense! (And that it is possible)

[Jeff_Hager]

Something happened to bar charts

So there are always seven numbers on the y-axis, the math calculates what numbers to show based on the data it’s given. The reason it looked nice above is because it’s the numbers from 0-6 so it was exactly 7 numbers. It seems like now, the max number is 5 in your data so it’s trying to get 7 numbers from 0 to 5 so that it can fit the bars. This is why there are decimal numbers.

[Divya_Puliani]

The issue I am facing is similar.

The Y axis gets quite confusing . These are 2 examples of challenges that I am facing:

1. The Y axis is supposed to display percentages which shouldn’t go beyond 100. The Y axis is however scaled as 0,17,34,…,102
2. The Y axis is supposed to display number of habits adhered to and should be 0,1,2,3,4. The scale however is 0,0.7,…4.2

Is there a workaround for this?

[Alex_Aldridge]

Hi - is there a workaround to this? Encountering a similar issue whereby I am displaying a consistent data set with values between 0 and 5 but the y axis changes depending on the min and max values, which means depending on the data displayed the bars are showing on different scales!

[SantiagoPerez]

Have you try quickchart.io?

Quickchart.io: the Cloudinary of Charts —on the fly charts!

GAME CHANGER! Stumbled upon this site today—a way to create on the fly charts using data from your Glide tables. Images render instantly and you can select one of 14 different charts, customize colors, styles etc all through URL parameters! The video below shows my first attempt to create a chart from scratch and implement it in Glide. Took me less than 5 minutes. End result: [Screen Shot 2020-09-17 at 10.10.46 AM]

[Alex_Aldridge]

Looks interesting, thanks!

I do like the native Glide charts and they look great - hopefully setting a min and max value on the axis can be added in the future!