I am unable to show mm:ss format on Y-Axis in a column chart. My data is in numeric format, I understand that the vertical axis doesn't understand strings. I have numerous methods but I am unable to gain the result I need.
I saw someone converted to "data" type then select customer number format in the axis of mm:ss...what in the world is "data" type? https://social.technet.microsoft.com/Forums/sqlserver/en-US/9ec99b67-3ae1-42f4-98f6-4339c1f4a501/ssrs-y-axis-using-time-format-hhhmmss-over-24
Just breaking out the seconds via division and ":" doesn't work but I am assuming that is because that method is creating a string which the axis can't read. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1ae2767f-5839-4686-b28e-a5d56c9e20d7/formatting-y-axis-in-mmss?forum=sqlreportingservices
I have methods from about 15 other links that I have tried to put into place without any success. I just wanted to ensure that everyone know I value your time and have been attempting to research this fix for 2 days now. Any help you can provide would be amazing.
I am in VS 2010