[AccessD] Fancy graphs from Access

Hi Doug,

You can make a variety of good-looking charts in Access.  This looks like a
good place to start:  http://www.functionx.com/access/Lesson32.htm

However, you may have to give up on pie charts.  The reason is that the
leader lines for each section of the pie end up on top of each other, and
they cannot be relocated in code (every pie chart I ever made in Excel
needed to have the leader lines manually located to be viewable).  I guess
if you turn the leaders off (if possible), then you can just use the legend
to show which pie section is for what.

I've made some interesting charts in Access.  It's tedious, and you
sometimes have to do some magic with queries, but hopefully your customer
will like them.   Expect to put some hours into developing each chart, and
charge accordingly.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Wednesday, February 04, 2015 16:30 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Fancy graphs from Access

I've just had a client ask how he can print some fancy formatted pie charts
and graphs from an Access database.  I don't have a clue - can anyone
suggest a work flow that he can use?  I can always build a query to get the
data out to Excel or ???, but from that point onward I have no experience.

Thanks,
Doug
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com