I have some data that I have to represent using calc.
If I select two columns that are next to each other (
$mergesort.$A$1:$B$101) the plot is created without any problem.
However, I want to select data from different plots. According to the official website I should use a semicolon and select the columns in this way :
However, when I add this thing as my datarange, the OK button at the dialog box gets deactivated and the text box turns to red. This happens just after I add a semicolon at the already selected area.
Am I doing something wrong?
By the way, I do not know if this plays any important role, but my chart is a line graph, and I also have data in both columns A and C
My problem is also shown at the screenshots below