Pivotchart Excel Free To Kick

I promised a commenter I would create a follow-up video demonstrating how I took those data sets and created a pivot chart that updated when you choose a new category.

Pivotchart Excel Free To Kick

Feel free to kick it around and test out some of the filters I demonstrate in the video.

You cant create a pivot chart in Excel 2011 for Mac.

Boo hiss) But not only can you not create one, you cant even use a report filter on the Mac.

But if youre creating a pivot chart, and theres the chance that anyone might have to access it from a Mac, you cannot use report filters.

He was in a hurry and asked me to just create screenshots of each of the charts, and he showed those to the client instead.

Ive never quite forgiven Microsoft for that.: (Yes, I take making data sexy very seriously.

And even though I said I wasnt going to get into chart formatting since Ive covered that in this post from my SMX Advanced presentation and this Search Engine Land post, I did anyway.

For instance, if I have a pivot table that includes monthly or weekly data on a particular customer that is also included in a chart, I simply change the customer name or the date range from the drop down selection in the pivot table.

I then select the whole chart, use command x to cut it, and then I use command v to paste it, and it displays with the new chart data.

Granted this is done automatically on a PC, but at least this is a way to continue to use a great machine (Mac) and still utilize Excel in the business world.

There are much more efficient ways to build dynamic charts using a combination of form controls and functions like SUMIF(S), IF, INDEX, and OFFSET (to name a few).

I have a bunch of tutorials on Search Engine Land and Marketing Land that show you how to set these up.

This guide provides step-by-step instructions on how to perform 66 unique marketing tasks using 15 reputable marketing tools (both free and paid).

Pivotchart Excel For Mac