Hiding cells so they still show up in charts.

[Jakub]

Hello,

I was wondering if there was a way to hide cells without them being deleted from the charts. Like if my data is 1000 lines long and I want to continuously add more stuff I don't want to scroll all the way down each time. I tried to highlight the row and hide it but than it deletes it from the graph.

I know i can shrink it down to 1px w/o making the data go away, but is there a way to hide it completely just like on Google Dox?

[Andy Pope]

On the Select Data dialog is a Hidden/Empty cells button where you can choose to display hidden cells