Chart problem

[Eld0]

Hello,

I got one workbook with a sheet which contains the data and 1 sheet which contains the chart based on the data. Some rows on the data sheet are hidden, so excel doesn't display the data on these rows in the chart.

Now I copy the sheet with the chart to a new workbook, everything seems fine. But when I close the first workbook, the copied chart in my new workbook shows all the data (incl. the data from the hidden rows).
When I open the first workbook again and refresh my copied chart, the rows dissapear again.

What can I do about this so my copied chart is exactly the same as my original chart?

Anyone?

thanx in advance,

Eld0

 

[RalphA]

One possibilty: Unhide the hidden rows, do a Cut (Ctrl+x), then Paste (Ctrl+v) them below the last normally visible row. Now do your chart and copying. Everything should work as you wish, now.