Using Excel2000... In ONE .xls file, I have one worksheet with columns
of data and a second worksheet with several charts based on those columns.
Since some of the columns are derived from others, I would like to HIDE
the derived columns.
But when I HIDE the columns, all chart series for those columns disappear!
No lines show up, the legends for those series go away, etc.
Unhiding the columns makes the chart series show up, so the charts still
retain the knowledge of the series spec.
Is there a way to force the charts to show data even if the source column