Hiding cells changes plots?

If you plot a group of cells, and then hide some columns, the plot changes, as if the hidden data weren’t there. Is this intentional or a bug? It seems like hiding should just be cosmetic, but isn’t.

Hi

Edit the chart▸Right click the data serie▸Format data seriesOptions tab▸Tick Include values from hidden cells

Regards