Line with markers chart problem?

**abiyubi** · 01-11-2015, 01:57 PM

I created a chart. It shows currency changes in time. I upload a picture.

Untitled.png

I will try to explain my problem. I set up times arithmetical (20.00-21.00-22.00...) but as you see in circle. I break arithmetical time series. How can i create time and distance ratio ? Example (if we say between 2.00 and 3.00 10 Centimeters. Between 3.00-5.45 must be 17.5 cm) but it is not?It is the same as the others. As you see in the picture. Please help me.

**MrShorty** · 01-11-2015, 06:41 PM

One possibility -- plot as scatter chart instead of as line chart. Times will then be treated as "numbers" rather than text categories. You may need to make sure your date and time data are combined into a single "serial" number (it is hard to tell from a picture exactly what is in each cell).

I would suggest reviewing these tutorials:
http://peltiertech.com/line-charts-vs-xy-charts/
http://peltiertech.com/Excel/ChartsH...ValueAxis.html
This one discusses how Excel stores date/time as serial numbers. http://www.cpearson.com/Excel/datetime.htm#SerialDates