Hidding Source Data in Charts

[PaiolaS]

When i hide a Row that contains chart values, that series
hides too in the chart, can i hide the source data rowns
and mantain the series in my chart ? How?

tks

 

[Debra Dalgleish]

1. Select the chart
2. Choose Tools>Options
3. Select the Chart tab
4. Remove the check mark from 'Plot visible cells only'

 

[PaiolaS]

Tks Debra

-----Original Message-----
1. Select the chart
2. Choose Tools>Options
3. Select the Chart tab
4. Remove the check mark from 'Plot visible cells only'


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.