I have a big set of data that I split it into 2 ranges (here I am just showing small data for clarification).
I want to draw one chart based on those 2 ranges, to get a result as the "Desired Result" chart. However, what I am getting now is the "Current Result" chart. The data range I am using as shown is:
My question is: Is it possible to draw one graph continuously based to ranges in different columns?
If that is possible, how can we achieve it?
The question How to merge x-axis data from two ranges? does not fit my case. In there, the values of
Y axis are all in the same column
A, and the values of
X axis are in two different columns
In my case, the values of
Y axis AND
X axis are in 2 different columns.
E for axis
F for axis