On Windows I use Excel to make charts and graphs from a small Access database I use for my business. Now I am on a Mac and trying to figure out how to do the same things I’ve done in the past. I’ve got an instance of MySQL setup and am able to make it do most of the things I want to do as far as creating the database. But the big problem I’m having right now is trying to visualize the data. I’m no office guru but on Windows I did this by connecting Excel to my Access database and then create pivot tables. I should be able to do this on a Mac, but it’s harder than I thought it would be. Excel needs a 3rd party ODBC driver (in Windows Microsoft ships with built-in drivers for connecting to Access). I went to a number of vendors last night and tried their products but was completely unsuccessful. Why is this so hard?
How can I do this on a Mac?
I’m not married to Excel. Is there some other product I can use to create charts and manipulate the data like I can in Excel?
If Excel is the best solution, is there a particular ODBC vendor people use? There are a number of them, but I just want one that will work relatively pain free. Is there step-by-step guide anywhere?