herclau
Do You would like to get range A2:B6 -data to look like Your chart?
... why those 'steps'? ... I skipped those.
... why XYChart? ... anyway sample of it.
... also other chart sample
All depends from real needs.
Why XY CHART?
Peltier Tech explains:
"... Another problem with a plain old column chart is that the bins look numerical, but the axis is categorical, and does not represent the numerical values of the bin boundaries. Unless you can do math in your head, and can force your mathematical brain to ignore what your visual brain sees, you don't know that the bins are of equal width In this case they are equal, but I've seen histograms which have unequal bin widths represented by equal width bars. another way of distorting the data .... "
The process to achieve the final arrangement to perform the XY Chart, explained by
Peltier Tech, is as follows:
From array 1, -105 is removed and a shift cell up is performed. And this is array 2. Array 3 is to set all values of array 1 to zero, and put it below 2; In array 4, only the -120 row was deleted.
Finally, array 5: with the 2,3 and 4 consecutive arrays we place them in the first upper cell of the left and use the command "Sort & Filter" / "Sort Smallest to Largest"
Is it possible to execute this manual process, with the help of formulas?