Help Changing Axis labels in Airchart Lite

[themmara]

I’m trying to create a grapht like this:

Currently I believe I have the data setup correctly with the exception of the X-axis. This is what I currently see:

See the editor here

I formatted as a number because when I selected formatted as text it wouldn’t provide me a list of text and it needs a list since it is for the x-axis. When looking into the element, the x-axis values are displaying the initial value so 0,2,4 instead of 0-2, 3-5, 6-8 etc. At a loss here open to all advice!

[ZeroqodeSupport]

Hi @themmara ,

Thank you for reaching out!

Based on your setup and screenshots, it looks like the issue is with how the X-axis values are being grouped and displayed. Since the Air Chart Lite plugin requires the X-axis to be a list, but you’re aiming for grouped ranges (e.g., “0-2”, “3-5”, etc.), here are a few steps to fix this:

Possible Fixes

Ensure the X-axis is a List of Texts

• Instead of formatting the values as numbers, try using formatted as text.
• If “formatted as text” isn’t providing a list, you may need to manually create a custom list of text ranges (“0-2”, “3-5”, etc.).

Use a Custom Grouping Approach

• Since Bubble’s group by function groups by exact values, it may not work for ranges. Instead, try adding a new field in your database (e.g., Moisture Frequency Range).
• When saving data, assign values like "0-2", "3-5", "6-8" based on the moisture frequency.
• Then, use this field for the X-axis instead of direct numbers.

Manually Define the X-axis Categories

• If grouping by range dynamically isn’t working, you can manually create a list of text values in a custom state (e.g., ["0-2", "3-5", "6-8"]).
• Then, match your data points to these labels using conditions in the workflow.

Helpful Resources

Check our Demo Page: Air Chart Lite Demo

Just a quick note: We provide general support for plugin functionality and bug fixes. Since this is more of an implementation question, we recommend checking out the Zeroqode Forum or the Bubble Forum for additional insights from other users.

Let us know if you need any clarifications!

Best,
Support Team
Browse all Zeroqode Plugins for Bubble

[themmara]

Any ideas how to stop the charts from skipping empty categories. For example: Lets revies the dates 2/3, 2/10, 2/17, and 2/24.
Series 1 has the following values:
2/3: 3
2/17: 1
2/24: 2

Series 2 has the following values:
2/3: 2
2/10: 1
2/17: 2
2/24: 5

instead of the graph automatically asserting a 0 for series 1 on 2/10. It just shifted all the data back. How do we go about mitigating this?

[ZeroqodeSupport]

Hi @themmara ,

Thank you for your message!

It looks like the chart is automatically skipping missing data points instead of treating them as zero. To ensure that all dates are displayed correctly, you can try the following:

1. Manually insert missing data points – In your Bubble database or data source, include an explicit value of 0 for Series 1 on 2/10. This way, the chart recognizes that there’s a value instead of skipping it.
2. Use a Complete Date Range – If you’re pulling data dynamically, make sure your date range covers all dates (even those without values) to maintain consistency in the x-axis.

Let us know if this helps.

Regards,
Support Team
Browse all Zeroqode Plugins for Bubble

[themmara]

So to clarify there is no way to dynamically add in something that do that? Because the dataset will never necessarily be complete and manual doesn’t make sense for this particular application

[ZeroqodeSupport]

Hi @themmara,

Thank you for your message!

Since Bubble doesn’t natively bucket numbers into ranges, here are a few ways to approach this:

Adjust Grouping Logic – Instead of grouping by exact numbers, try categorizing values into predefined ranges before passing them to the chart. One way to do this is by adding a field in your database that assigns each entry a range label (e.g., “0-2”, “3-5”, “6-8”) based on its value.

Format X-Axis Values as Text – Since the chart requires a list for the x-axis, you can format the values dynamically. For example, use :format as text and set conditions so values between 0-2 output “0-2”, values between 3-5 output “3-5”, etc.

Check Plugin Settings – Some charting plugins have built-in support for categorical x-axis values. Air Chart Lite might not handle this automatically, so if needed, a plugin like Air Chart Pro or ApexCharts could provide more flexibility.

Looking forward to your reply!

Regards,
Support Team
Browse all Zeroqode Plugins for Bubble

[agilityhive]

I have a similar issue with a different chart plugin. IT’s not the chart plugin it’s generating a dataset that includes zeros when it is a count. You can’t use defaulting to on a count, I even thought to add 0.000000001 to the results but can’t even do that in the data set.

Any suggestions gratefully received.

[ZeroqodeSupport]

Hey @agilityhive ,

Thanks for reaching out!

Could you share which chart plugin you’re using? Also, a few more details would be helpful:

1. What data source are you using for the chart? (Is it a database query, an aggregation, or something else?)
2. Are the zeros appearing in all cases, or only in specific conditions?
3. Are you using a repeating group or another method to generate the dataset?
4. Have you tried applying a filter to exclude zero values? If so, did that change anything?

With a bit more info, WE can suggest a better workaround for your use case!

Looking forward to your response.

Regards,
Support Team
Browse all Zeroqode Plugins for Bubble