View Single Post
  #3  
Old September 25th, 2003, 07:25 PM
PaiolaS
external usenet poster
 
Posts: n/a
Default Hidding Source Data in Charts

Tks Debra

-----Original Message-----
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

.