Bar Graphs: Compare and Contrast under Access/Excel?

mytfein
mytfein used Ask the Experts™
on
Hi EE,

How would you compare and contrast graphs under Access and Excel?

tx, sandra
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel is better.  The end.

Author

Commented:
Hi Peter,

I went to Excel to experiment with a chart based on what I learned about Access graphs last week
via EE.

I have better control of graph in Access.
Was wondering why you like the Excel side?

tx, s
MIS Liason
Most Valuable Expert 2012
Commented:
mytfein,

1. Excel 2007 has quite a few graphic options that are not available in Access.
2. As Pete states, the Excel graphing interface is much more user-friendly that the one in Access (as well you know)
But may people are locked into Access, so Excel may not be an Option.

Besides you did not provide any examples of this mysterious "compare and contrast graphs" functionality you want, so it is impossible to tell if this can be done in Access or Excel at all...

JeffCoachman
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
Please buy this book:
http://www.amazon.com/Excel-Charts-John-Walkenbach/dp/0764517643/ref=sr_1_1?ie=UTF8&s=books&qid=1248148726&sr=1-1
Or
http://www.amazon.com/Excel-2007-Charts-Spreadsheets-Bookshelf/dp/0470044004/ref=sr_1_3?ie=UTF8&s=books&qid=1248148726&sr=1-3

It answers many of the questions you have been posting here lately.
It is specfic to Excel, but since Excel's graphing engine is similar to Access', most of what is presented in this book will be applicable in Access as well.

JeffCoachman

Author

Commented:
Thx Jeff for the info...

I did not know that whole books could be written just on charts.....

tx, s
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I can't see how either of my posts "Answered" your question, when you did not present an example of this mysterious "compare and contrast graphs" functionality you want.
?

Author

Commented:
Hi Jeff,
You did:
    you elaborated more on pros and cons of excel
    and provided books

tx, s
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
OK.

;-)

Jeff

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial