# Set Axis Scales and Filtering Non-Existent Values in Line Chart Reports

**URL:** <https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871>\
**Category:** Get Help\
**Created:** [November 29, 2024, 4:19am UTC](https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871 "2024-11-29T04:19:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![njyo](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/njyo/32/923_2.png) [@njyo](https://community.fibery.io/u/njyo)\
**Post date:** [November 29, 2024, 4:19am UTC](https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871/1 "2024-11-29T04:19:22Z")

</div>

Hi,

I’m trying to set up a report with line chart that tracks exchange rates, as you can see here:

 ![2024-11-29 at 12.14](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/25e19e690c4dd7b5df6194b779bcecba38b3233f.png)

I’m facing two challenges:

1. While I’ve filtered the records, where there is no value, the red line still is being displayed as zero. Instead, there should be no line, where there are no values.
2. In this case the rate is around 80 and as there is no way to set the scale on the y-axis, any fluctuation is really hard to see. Is there any way to set the min/max values for the y axis? Ideally, I’d want to set them dynamic like (min value-10% and max value +10% or similar).

I didn’t find anything in the [Reports Help Docs](https://reports-help.fibery.io/guides/chart_editor).

Thanks!

---

<div class="post-metadata">

**Author:** ![Bronn](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@Bronn](https://community.fibery.io/u/Bronn)\
**Post date:** [December 10, 2024, 6:31pm UTC](https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871/2 "2024-12-10T18:31:39Z")

</div>

> [@njyo](#):
>
> Is there any way to set the min/max values for the y axis?

+1  
I would also like to be able to do this.

---

<div class="post-metadata">

**Author:** ![NicolSpies](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/nicolspies/32/4317_2.png) [@NicolSpies](https://community.fibery.io/u/NicolSpies)\
**Post date:** [January 22, 2025, 9:40am UTC](https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871/3 "2025-01-22T09:40:00Z")

</div>

+1  
I need this too

---

<div class="post-metadata">

**Author:** ![Eva\_Folch](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/eva_folch/32/11814_2.png) [@Eva\_Folch](https://community.fibery.io/u/Eva_Folch)\
**Post date:** [March 27, 2026, 3:45pm UTC](https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871/4 "2026-03-27T15:45:43Z")

</div>

Is this still not posible?

---

<div class="post-metadata">

**Author:** ![nathan\_jay](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/nathan_jay/32/11899_2.png) [@nathan\_jay](https://community.fibery.io/u/nathan_jay)\
**Post date:** [April 2, 2026, 12:28pm UTC](https://community.fibery.io/t/set-axis-scales-and-filtering-non-existent-values-in-line-chart-reports/7871/5 "2026-04-02T12:28:45Z")

</div>

+1 would be great

The hack is to use an Annotation to scale the y-axis. You can set the line colour to white FFFFFF and use fixed values or formulas so you should be able to find a way

Also for the “display nothing” this same problem happens with Excel graphs. The hack is to make the values “N/A” instead of 0 so there will be no visible line (rather than a line at 0). I guess because that’s text that can’t be rendered on a numeric axis? I haven’t tried in Fibery but maybe that will work?