how to turn of a series in data sheet of a power point chart using macro

Hi
I am writing a macro to automate the power point presentation assigning values to data sheet(chart) from a excel sheet.on one instace in a bar graph, i have like 100 bars to be diaplayed and when i add values to the datasheet the graph looks so messy.

Is there any way that i can disable a range and show only a certain range by a macro.I know i can do it manually by opening the data sheet and double clicking the column header to enable the whole column and disable it

Can anybody help me in providing the tip.
Many thanks in advance

Regards
Chepyala

In your macro have you tried hiding the columns?

Range("G:G").EntireColumn.Hidden = True

Is that what you mean by "disabling" the column?

"chepyalarr" wrote:

>
> Hi
> I am writing a macro to automate the power point presentation assigning
> values to data sheet(chart) from a excel sheet.on one instace in a bar
> graph, i have like 100 bars to be diaplayed and when i add values to
> the datasheet the graph looks so messy.
>
> Is there any way that i can disable a range and show only a certain
> range by a macro.I know i can do it manually by opening the data sheet
> and double clicking the column header to enable the whole column and
> disable it
>
> Can anybody help me in providing the tip.
> Many thanks in advance
>
> Regards
> Chepyala
>
>
> --
> chepyalarr
> ------------------------------------------------------------------------
> chepyalarr's Profile: http://www.excelforum.com/member.php...o&userid=31103
> View this thread: http://www.excelforum.com/showthread...hreadid=507708
>
>