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

C

chepyalarr

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
 
C

Charlie

In your macro have you tried hiding the columns?

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Macro to Select text from a point given to a specific word 2
How I can set dynamic pivot table ONLY when I have enough data point 1
add a chart in a Add-In 1
How do you chart data from multiple sheets within a workbook? 3
Hiding 0 value data labels in chart 7
[Excel 2010] fails to record macro for Custom Error Bars 0
Macro to Combine Data from Multiple Sheets with Cell References 4

Top