# Perspective XY Chart yAxes Value stuck with one format **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [March 23, 2020, 8:27pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338 "2020-03-23T20:27:02Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![jgardner](https://avatars.discourse-cdn.com/v4/letter/j/a587f6/32.png) [@jgardner](https://forum.inductiveautomation.com/u/jgardner)\ **Post date:** [March 23, 2020, 8:27pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338/1 "2020-03-23T20:27:02Z")
I’m creating a pareto chart so I have two Y axes - count\_axis and percent\_axis. I also have two series - failure\_count and cum\_percent. - Both axes are render: value - count\_axis is value \> format: #,### - percent\_axis is value \> format: #% - count\_axis is index 0, percent\_axis is index 1 - percent\_axis is appearance \> opposite: true - Windows / 8.0.10 Problem: as soon as I set the percent\_axis \> value \> format to percent, it displays count\_axis as a percent. Instead of 400, it is 40000%. Change the percent\_axis to number and count\_axis changes to an integer. This can be seen with the default XY Chart data. Drop a new chart in and change yAxes \> 1 \> value \> format \> percent. Both axes will change to percent. Screen cap attached. I couldn’t find a pre-existing bug tracker for this. ![yaxis%20value%20format](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a37e21d5b7185387108b995e9ac2d8bf47f74f2e.png) ---
**Author:** ![jgardner](https://avatars.discourse-cdn.com/v4/letter/j/a587f6/32.png) [@jgardner](https://forum.inductiveautomation.com/u/jgardner)\ **Post date:** [March 30, 2020, 3:36pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338/2 "2020-03-30T15:36:17Z")
Has anyone else seen this behavior? As I mentioned, you can test it really quickly by creating a default chart and switching the 2nd Y axis to % format. ---
**Author:** ![lwood](https://avatars.discourse-cdn.com/v4/letter/l/977dab/32.png) [@lwood](https://forum.inductiveautomation.com/u/lwood)\ **Post date:** [March 30, 2020, 6:22pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338/3 "2020-03-30T18:22:53Z")
That happened to me too. I didn’t have time to troubleshoot so I just put the % in the axis label. ---
**Author:** ![jgardner](https://avatars.discourse-cdn.com/v4/letter/j/a587f6/32.png) [@jgardner](https://forum.inductiveautomation.com/u/jgardner)\ **Post date:** [March 31, 2020, 8:39pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338/4 "2020-03-31T20:39:42Z")
Thanks @lwood, I like the workaround. I used it. Took the SQL in the named query from “Cumulative \* 1.0” -\> “Cumulative \* 100” and changed yAxes[1] to Integer format and viola. I haven’t heard if this is on the radar as a bug. I can’t imagine it’s intentional behavior. ---
**Author:** ![Scott.kaempfe](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@Scott.kaempfe](https://forum.inductiveautomation.com/u/Scott.kaempfe)\ **Post date:** [February 25, 2021, 5:55am UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338/5 "2021-02-25T05:55:11Z")
I have the same issue. Any fixes other than leaving it a decimal or changing the data to \*100? Does this happen on all charts with two Y or just the column/line combo? ---
**Author:** ![lwood](https://avatars.discourse-cdn.com/v4/letter/l/977dab/32.png) [@lwood](https://forum.inductiveautomation.com/u/lwood)\ **Post date:** [March 9, 2021, 8:52pm UTC](https://forum.inductiveautomation.com/t/perspective-xy-chart-yaxes-value-stuck-with-one-format/33338/6 "2021-03-09T20:52:58Z")
Looks like this was finally fixed in 8.1.3, I haven't installed it yet but: > [@XY Chart - Number format for one axis is overriding other axes](http://forum.inductiveautomation.com/t/xy-chart-number-format-for-one-axis-is-overriding-other-axes/37666): > > There seems to be a bug with the XY Chart where the number format set on one axis is applied to the other axis or for another configuration object on the same axis. I experienced this bug on Ignition 8.0.12, then tried on 8.0.15 and saw the same thing. Consider this screenshot: Note how the left side, right side, and bottom are all currency formatted. This is what is displayed even though I only set a single axis to have a currency format. The other two number…