Chart not Plotting Hidden Rows/Columns

[Chakri007]

Hi All,

I am faced with a pecular problem,
I have mapped data from Sheet1 to Sheet2 and created graphs in Sheet2 using the data.
but when I hide the rows in Sheet2 the Graph is being cleared off.
Can anyone please give me a solution so as to display the Graph in Sheet2 while hiding the rows in the same sheet.

Thanks in Advance
Sridhar R

Please find attached the File displaying the same

[Dave Hawley]

With the chart selected, go to Tools>Options>Chart and uncheck plot visible cells only

[Chakri007]

Thanks a Lot Dave for the quick reponse