VBA code to change MSGraph formats and location

M

Marco

Hi
I have 2 questions:
1) Is there a resource that lists all the VBA code to modify the formats in
MSGraph.
I know a few of the basic ones like . chartype = xlPie or
..charttitle.font.size = 12
I am looking for code to specifically modify the plot area's colour and
border and what all the different codes for colours and borders are?

2) I have a command button that creates the pie chart. What is the best way
to place the graph in a certain location (ie: bottom of page 3 in a document)

Thanks
 

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

Top