I have a table of data in a Google spreadsheet that we want to use to create multiple charts. The issue we are facing is that some of these charts omit certain columns. We don't want to remake the table multiple times. Example:
- Row 1 = Labels for Items 1, 2 and 3
- Column A = Dates
- Column B = Item 1
- Column C = Item 2
- Column D = Item 3
Items are in a specific order and the order cannot be changed. (Actual data has more columns than this and reordering it to satisfy all required charts would be impossible to do within the same table.)
Charts
- Data range for a chart with all the data: Sheet1!A1:D5
- Data range for a chart with Item 1 & 2 only: Sheet1!A1:D4
- Data range for a chart with Item 2 & 3 only: ????
It is situation 3. where we are having difficultly, since we need column A for the dates and column C & D for the values, but need to skip column B.
Is there a way to ignore specific columns within a dataset?
What is the proper reference to use in this situation?