Hiding data points in a column chart

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
 
A

Andy Pope

Hi KD,

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

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

Cheers
Andy
 

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

Access Combination Chart Types Access 2010 0
Values in stacked column chart (2D) 1
step chart 1
Powerpoint Chart not updated with the data assigned in its datashe 3
Remove (or Hide) Points in a Graph with VBA 0
XY Scatter Chart Data Markers 1
de/selecting rows of data in a chart, 2007 1
connect points on an X Y scatter chart 5

Top