Charts in reports

[lmn]

Is it safe to say that if one would want a very fancy -presentation style - report - with charts/graphs - that Access is not necessarily the place to go?

The charts are very ugly (can't come up with another word).

I have a report that looks heinous. I've added 2 subreports - one of which is a graph and on is a table - along with the main data piece of the form in the detail section. My first problem is that I can't find a place to put the graph chart except the header or footer - but no matter where I put it - the text looks garbled and it never sizes appropriately.

It would be simple to export some data and create a pretty Excel report.......should I just do that or is there hope in Access for fancy graphs and presentations????

 

[WildHare]

Is it safe to say that if one would want a very fancy -presentation style - report - with charts/graphs - that Access is not necessarily the place to go?

AFAIC, Yes. Try shooting your data to Excel and building the graph there. It's a lot more functional, and not all that difficult to do. You can use VBA to create an Excel Chart Object, assign the data series values, format the chart and do all that fancy stuff. I have some example code I use at work that I can offer if you need a slight push in the right direction.

Jim



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[lmn]

Yes - that'd be great if you could send me some sample code - I'm not really a VBA expert.....

Email is lisa_m_nelson@yahoo.com


Thanks!