View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bon Bon is offline
external usenet poster
 
Posts: 23
Default How to take chart and paste into Access form

Hello all

I need to paste two pie charts in the MS Access 2000 Form. Actually, it
is one of the Form in Tab folder. This is used to give customers a
quick visual summary of how many do they buy for each product.

I created a pie chart in MS Excel 2000. Data source are from MS Access
2000 database. After the charts are created successfully, I want to
paste them into Access Form. But, I don't want the excel workbook run
everytime when the tab folder is clicked. How do I implement it? Should
I use MS Graph on doing it? If so, can you give me some sample code? I
can find any information on creating pie chart using MS Graph.

Thanks

Cheers
Bon