simple question on graph

[brindha_shree]

hello,
i did a chart using source data from a sheet called note.i have to hide some columns in the sheet(which is used as a source data for the graph), but after i hide the column the data didnt show in the graph...is there anyway that i can use to avoid this problem?
thank you

Regards,
Brindha

 

[Derek]

Hello
This is an extract from Excel Help which seems to give you the answer you need.

Show only visible worksheet data in a chart
You may want to hide and display details in an outline with subtotals, or filter data by specific criteria by using one of the Filter commands on the Data menu. When you hide, display, and filter data on a worksheet, the corresponding chart shows only the visible rows and columns.

Click the chart.


On the Tools menu, click Options, and then click the Chart tab.


Select the Plot visible cells only check box.
Notes

To show all worksheet data in the chart, even if some rows or columns are hidden, clear the Plot visible cells only check box.


This procedure does not apply to PivotChart reports

regards
Derek

 

[Mark O'Brien]

Instead of hiding the columns, try setting their widths to something really small. e.g. set the column width to 0.05, anything less than this will be basically the same thing as hiding the column and will make the data invisible to the graph again.

HTH

 

[brindha_shree]

hello
thank u very very much
my prblem solved...

thank uuu

Regards,
Brindha

 

[SamS]

another option available

place chart on another worksheet and Show Data Table from Chart Options then hide the data worksheet - awkward if continuosly updating the data but it has its uses