Hide Rows But Keep Values In Charts

[mouse88]

I have a few percentage calculations which are to go in a chart. In the actual data table these percentages are hidden. Is there any way and can still get them to display in mt chart?

Thanks

Matt

 

[wigi]

Hello,

did you use Google first?
I used:

excel 2007 chart plot hidden rows

and found:

http://www.techrepublic.com/blog/msoffice/display-hidden-data-in-an-excel-chart/1927