Put time on y-axis (CR XI)

Post Author: yyu

CA Forum: Charts and Graphs

Hi there,

I'm trying to make a line chart to show the development of a set of items depending on distance and time. X-Axis shows the distance and Y the time. Each serie in the chart represents an item. On change of distance and item, time values should be shown.

As I was using time in seconds as NUMBER, this runs well. To convert the seconds into a more readable format such as HH:MI:SS I'll have to give up the type NUMBER, which makes it impossible (for me at the moment) to show time on Y-Axis any longer.

Does anybody have an idea? Which data type else could be used on Y besides NUMBER? Or can I use a formula to format Y?

Thanks!