Forum Discussion
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.
jamaalmoosa Please see attached. Not entirely sure that I follow everything you try to do, but your time line jumped from 2 to 3 hours (row 195) where all previous increments were for 1/100 of one hour. Inserted the third hour in hundreds and calculated a linear charging rate, during which distance traveled remains at 194. At time 3.05, energy levels decrease again, presumable because you were driving.
