I have a subtotal row that I want hidden in a main spreadsheet, but want to
use the data from it to create a chart. Whenever I hide it, the chart values
disappear as well. Anyway to change that?