Archive for June, 2010

Charts & InDesign

June 17, 2010

Do you like fancy charts & graphs in your InDesign publications? The options used to be pretty limited, with cutting & pasting from Excel being the easiest. It was just too bad that they were so low quality that printing them commercially was a disaster.

Then Adobe added the option into Illustrator. You could, at first, manually create them and then Adobe added the Graph tool. I’ve always found it to be somewhat limited but then that may just be me.

So what’s my point? Well the folks over at InDesign Secrets blog pointed out that there is an add-in script available for InDesign for creating charts & graphs. It may be worth checking out.

Customizing a Pivot Table in Excel

June 7, 2010

I don’t know about you but I use Pivot Tables all the time. It’s a great flexible way to view your data in many different ways. Now chances are there will be times when you want to hide certain items in your table. Or only look at a few of those items instead of everything. Up until now I’d used the built in “filter” button that automatically comes with the table. But that can be a pain if you have a lot of items, you have to scroll down through the list check or unchecking all those items.

Well the folks over at the Contextures blog have this handy post on how to make that process easier. Check it out.