1. Select the chart
2. Choose ToolsOptions
3. Select the Chart tab
4. Remove the check mark from 'Plot visible cells only'
PaiolaS wrote:
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?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html