Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Hidding Source Data in Charts
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Hidding Source Data in Charts
 |
Hidding Source Data in Charts |
|
|
Thread Tools | Rate Thread |
25-09-2003, 06:50 PM
|
#1 |
|
Guest
Posts: n/a
|
Hidding Source Data in Charts
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  |
|
|
25-09-2003, 07:12 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: Hidding Source Data in Charts
1. Select the chart
2. Choose Tools>Options 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 |
|
|
|
25-09-2003, 07:25 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: Hidding Source Data in Charts
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' > >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 > >. > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
