Dan Waters
dwaters at usinternet.com
Tue Oct 14 14:29:52 CDT 2008
Hi Mark, You can do almost anything with MS Graph that you can with Access. That being said, you can make a set of charts in a single report that will look almost exactly like the original powerpoint presentation. MS Graph works in reports (or forms). Create a new report and add an unbound frame. The wizard will ask you what you want to put in it - select MS Graph (or you could select Excel chart also). Now you can work with the properties of the charts and a query as the datasource for the charts to get what you need. You can put multiple smaller charts on one page or just one chart per page. I've made some nice looking charts - the real trick is to get the datasource to give you that data you're looking for. Good Luck! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Tuesday, October 14, 2008 1:41 PM To: Access Developers discussion and problem solving Subject: [AccessD] Charts and Executives... Hello All, I have just recently( and temporarilly I hope) had a report dropped in my lap that goes to the world and everyone...and the execs in that list are quite comfortable with how things look and don't want alot of change. That being said...it is a powerpoint presentation...it has about 15 graphs. Each 1 apparrently has an Excel spreadsheet embedded in it?!?!?(I don't work with power point that much)...this would explain why the file is so large. Anyway...these graphs are all populated from a copy of the same datasource...just filtered. Apparently the person doing this prior would go to each graph and past the new data and refresh a pivot. This data is a year over year comparison. I was thinking of bringing it into access...but how would I take a graph out of access and put it into excel or powerpoint? Any ideas? Thanks, Mark A. Matte _________________________________________________________________ Want to do more with Windows Live? Learn "10 hidden secrets" from Jamie. http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!55 0F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com