I would like to create a plot whose range extends as new columns of data are added. I have read that dynamic named ranges are not available in Sheets, and that named ranges are not allowed in plot definitions. My data range does not start in column A but, say, in column P. I would be happy if it could extend indefinitely. In the case of a single row, this can be achieved by using, e.g., P2:2 but the data range for the plot requires more than one row. Is there a similar syntax I could use here ?

  • 1
    do you have a set amount of rows? If you do, then you can just do P2:10.
    – David Tan
    Commented Nov 3, 2022 at 8:40
  • So simple ! How could I miss it ? Thx
    – jmichel
    Commented Nov 3, 2022 at 8:52


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.