Graph is taking column as X-axis rather than the cell value. Does anyone know how to rectify this?

jamaalmoosa I suspect that you did not link the X-axis labels to the Distance column. The labels in your picture seem to just count the number of data points. Having said that, allow me to suggest another chart that may represent your data better.

As you mention, you have three sets of data, Time, Energy and Distance. However, your chart only takes the latter two into account. Energy levels decrease (consumption) and increase (charging) over time. Distance traveled is also related to time as time progresses during both travel (consumption) and stand-still (i.e. charging).

Time is the factor that combines the other two and should therefore be on the X-axis. Then you could put the Energy part on the primary Y-axis and Distance on the secondary Y-axis. The chart would then look like in the picture below. I just made up some numbers to create a shape that resembles your picture.