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.
Riny_van_EekelenThanks a lot for your help, much appreciated. However, I seemed to be having some trouble when attempting to put time on the X-axis, Excel just doesn't seem to be allowing this. I have attached my file for reference. I am working on sheet no. 2.🙂
jamaalmoosa Friends, why not plotting scatter chart which is the best suited chart to treat numbers as "maths numbers" and plot graphs as on "standard mathematical graph paper" i.e. Y on X as per scale decided by numbers ?
same result is achieved without any data manipulation (interpolation), benefit over line chart is that just series are selected, and Excel just plots it without us realizing...
( and that the time was jumped by an hour is just a data fact )
Refer sheet3 of attachment
amit_bhola Hi Amit, thank you for your solution. I was using the column due to the better visual representation but your solution is also something I was unaware of. Thank you!