I am having a chart in power point. I want to hide the some column in datasheet so that it should not display in chart but dimmed.We can do following task manually in chart datasheet as follows ..

You might sometimes want to chart only part of the data you entered in a datasheet. You can hide selected columns or rows of data by double-clicking on either the column letters (A, B, C, and etc.)

You would open the datasheet, and then double-click on the column heading, C to hide the Chat data. The image below shows that the data in column C is still readable in the datasheet, but it is dimmed, and the chart now shows only bars for the data entered in columns A and B.

My question is how it is possible to do by macro. Please help me on this.

have you tried using the macro recorder ?
use that first to get an idea of what properties
need to be used etc.

alun