View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KD[_4_] KD[_4_] is offline
external usenet poster
 
Posts: 3
Default Automating PowerPoint

Hi,

At the moment I have written a macro that takes data from
Excel and puts it onto the Graph sheet behind a
PowerPoint chart - I want to be able (in the macro) to
only show the first 10 data points on the chart HOWEVER I
still want all the data to be contained on the Graph data
sheet behind the PowerPoint Chart.

My problem is : I can get the data into PowerPoint, I
want to show the first 10 but I can't then "hide" points
11 onwards, can anyone help?

Many thanks in advance

Kevin