I want to plot the chart of 2 data series. They are in column A and B. But their first and last line can vary and they are given from cell C1 and C2.
Charts in Excel does not seem to accept the use of the INDIRECT function. Could you provide an example of a solution ?