# Can't make bar chart work with math values as Y-axis **URL:** \ **Category:** Report a Bug\ **Created:** [February 17, 2021, 3:00pm UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932 "2021-02-17T15:00:07Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![XceL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xcel/32/91079_2.png) [@XceL](https://community.glideapps.com/u/XceL)\ **Post date:** [February 17, 2021, 3:00pm UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/1 "2021-02-17T15:00:07Z")
Hey guys, I have a dashboard screen with revenue related charts My data is a sheet with sales items, all having a date + time I have created a ‘month’ column (format YYYY/MM) using math + template columns for my chart x-axis And I am trying to show my profits as Y-axis. The profit is simply sale price \* commission / 100 When I use the profit column, it shows 0 for all months, although I can see the values in data editor Let me know if there is anything I do wrong ![Values are there in data editor](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b94fe55b382aa75372630ce85251ca07fbd7aeb.png) ![chart shows no data for y-axis](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cfc6431748c436ed26b63d15ed10c2381bf7f981.png) PS: When I use the price column instead of profit math column, it works fine, so the template Month column seems fine. Thanks in advance for the help Cheers Allan ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 17, 2021, 4:38pm UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/2 "2021-02-17T16:38:23Z")
Does it work if you remove units (euro) from the math column, then apply units through the chart settings? Just wondering if it’s not recognizing it as a number. ---
**Author:** ![XceL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xcel/32/91079_2.png) [@XceL](https://community.glideapps.com/u/XceL)\ **Post date:** [February 17, 2021, 5:00pm UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/3 "2021-02-17T17:00:31Z")
Hey Jeff, Same with or without the unit ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 17, 2021, 5:25pm UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/4 "2021-02-17T17:25:26Z")
Just for the sake of trying, can you create a template column that duplicates the value in the math column? May have to remove units. Then use the template column in the chart. Otherwise, this seems like a bug to me. ---
**Author:** ![XceL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xcel/32/91079_2.png) [@XceL](https://community.glideapps.com/u/XceL)\ **Post date:** [February 17, 2021, 6:16pm UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/5 "2021-02-17T18:16:31Z")
> [@Jeff\_Hager](#): > > can you create a template column that duplicates the value in the math column? Still displaying 0 for all months Will leave it to the Glide team to fix then. Thanks for your help debugging @Jeff_Hager🙏🏾 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 18, 2021, 12:06am UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/6 "2021-02-18T00:06:26Z")
Any chance you have row owners for this app? Have you tried seeing this on a real device? ---
**Author:** ![XceL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/xcel/32/91079_2.png) [@XceL](https://community.glideapps.com/u/XceL)\ **Post date:** [February 18, 2021, 6:56am UTC](https://community.glideapps.com/t/cant-make-bar-chart-work-with-math-values-as-y-axis/22932/7 "2021-02-18T06:56:40Z")
> [@ThinhDinh](#): > > Any chance you have row owners for this app? ThinDinh my man! The commission was indeed coming from a row owner-ed table I switched to a duplicate table and it’s now working Thanks!! I guess what confused me is that the lookup does not show the hidden values greyed out like in the table itself Anyway I will try to keep that in mind, thanks mate and thanks again Jeff for the help debugging earlier