Showing mm:ss on Y-Axis for Column Chart

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

August 27th, 2015 8:10pm

Hi Royals4630,

In your scenario, what are the values in your numeric column? If these numbers can t be converted to time part, we can never format the data part for these number. Please share some sample data for our analysis.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
August 28th, 2015 12:07pm

Hi Royals,

Please try this

In the axis properties of Y axis , go to number, select custom and then type mm:ss there.

August 28th, 2015 12:49pm

Milan, I have done this but unfortunately when previewing the report the axis only shows mm:ss versus an actual value.

Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 7:04pm

Qiuyun, I have included the simplest set below:

Rangegroup seconds
2015-04 702.5601336
2015-05 701.8471979
2015-06 638.3040997

August 31st, 2015 7:06pm

These are in INT form within the table but I converted them again into INT in the event something was lost in translation and still no affect. I can change the axis to default or number and I get an axis that has the true value of seconds (0-800) or so. Why I can't get that number broken into mm:ss is beyond me.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 7:10pm

Any ideas out there?
September 1st, 2015 7:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics