Create Chart Macro from Report - Question

[dontuch_dg]

Hi, I am looking for a suggestion.

The attach file has tab Report with alot of data and charttest.
1. Can all the 6 charts be created by one macro?
2. Use a button to update?

I tried to test my 2 pie charts using the code from the website:
The bottom ActiveCharts has errors.
http://pubs.logicalexpressions.com/P...cle.asp?ID=390

Please Login or Register  to view this content.

Thanks,

[Andy Pope]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[Andy Pope]

These changes wil at least get the code to run

Please Login or Register  to view this content.

[dontuch_dg]

Thanks Andy, I tried to remove the legend and include those labels into the pie? I am new to this site; How do I insert "solved" to threads?

[Andy Pope]

In the bar above the posts is a menu item How To...? with link to mark a thread solved.