Making chart with hidden Data

[dandigger]

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?

 

[Debra Dalgleish]

Select the chart, and choose Tools>Options

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?

 

[dandigger]

Thank you very much!
Such an outstanding community. Much appreciation.