Forum Discussion
selecting the data line in a chart isn't giving me click&drag function in both data fields
I have a data line in a chart, plotting the data from cells in two columns. Until recently, I could select the plot line in the chart, the data cells would be highlighted, and if I selected any one o...
are you sure you selected a specific line? When I select the CHART the data is highlighted and when I change the range then both x and y change but if I select the individual line then only that column changes. And btw that only works if the range is the same for each (e.g. A1:A100, B1:B100, C1:C100 but doesn't work if the ranges are different lengths like A1:A100, B1:B90, C1:C80)
here is screenshot of me sliding the range up and down (it had included all the data and I click 1 of the corner handle and slid it up and as you see the other column slid up the same)