Excel graphing
Excel graphing
I have this basic graph(s) made in Excel and it's cool and all, but there's one "small" problem. The difference between 2 points of data (x axis) isn't constant. Is it possible to extrapolate data in between and somehow make the graph more accurate. I hope you understand what I mean
Yes, you can adjust the scaling of each axis independently. Just click on the axis and set its own range or scale as needed.
You can improve the graph's precision by adding additional data points. If more information isn't available, it's difficult to enhance accuracy easily. You might try adjusting your interpolation technique. However, since I haven't used Excel for this task, I can't provide specific guidance on that. Typically, spline interpolation is the most effective approach.
The issue arises because you're combining two separate datasets. To maintain consistent timing, place each line in its own dataset—such as date/time in column 1, the first line in column 2, and the second line in column 3. This approach works best for graphs and can improve organization if you're using different tabs. Another solution is to align the x-axis with matching time or date markers across all datasets.