Hiding data points in a column chart

  • Thread starter Thread starter KD
  • Start date Start date
K

KD

Hi,

I am trying to write a vba macro that, when presented
with a column chart with a single series of more than 10
data points, it will hide all those data points from 11
onwards. I still want the data to be on the Graph
datasheet but I do not want to see the data on the chart -
I know that I can do this manually by double clicking on
the relevent columns of the datasheet but is there a way
I can do this using vba so that I can save time and
effort?

Many thanks
KD
 
Hi KD,

You need to use the Include property of the graphs datasheet object.

Graph.DataSheet.Rows(2).Include = False

Cheers
Andy
 
Back
Top