How to stop Chart from hiding points when part of data is hi

[Brian]

How can I stop a chart from hiding points when part of data is hidden by a row group or other method?

Details:
I have been given a spreadsheet with a data tables and charts on the same page.

There are several input cells in row #1 where the user selects and enters data.

Then there is a data table (with formulas based on the input cells.)

Then there is the chart.

I would like to keep the chart and input cells together on one page because the user interactively changes values and evaluates the values based on the chart.

However, I would like to be able to easily hide/unhide the calculation table, so I simply used a group by rows for all except the table title.

But when I hide the table, all the data disappears from the chart! I can see how this could be a useful feature, but I don't see how to turn it off!

Thanks,

Brian

[Asala42]

Hey,

I don't know of an option (ie setting) that would allow the chart do that. However I'd probably go with a stealth approach.

In short, I'd have a (hidden) data sheet that is linked directly to the user's data entry sheet - and base the chart off the data on the hidden sheet. That way, when data is hidden or filtered on the user sheet, the chart would remain the same.

Hope that helps somewhat,
Adam

[Brian]

Thanks,

I thought of that, but it is distastefull.

Regards,

Brian