Hello!


I would be really really greatful if someone could guide me through the process of editing the Y axsis of a chart so I can customize it as I would like it to be.


I've searched through multiple sites for help or tutorials and I have spent several hours trying to figure this out, but I'm stuck in my process.
I want to create a simple line with Data1 to Data2. Data1 can simply be 0, and Data2 any number, like 100.

And then, I want the Y axsis to show another value with certain invervalls. In this example I would like the Y axsis to be "time". And the time should go from 0 to 60, with 3 secound intervalls so I can see where the line is at exactly 36 secounds.


Now how can I do this? I've tried and tried in any way I can imagine. I've tried to customize and I've tried getting help from people who use excel 2003. Nothing have worked and this is my last resort. Please help me!

Put numeric data down a column.
In the column to the right, put the numbers that represent number of seconds.
Select the range and insert a Scatter with only markers
Double-click on the vertical axis and change the Major Unit to Fixed and 3.