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.

Excel Pivot Charts 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.

Excel Pivot Charts How To Change Those

But you can see a quick tutorial on how to change those dashes to zeros or check out my more comprehensive post on number formatting on the Search Engine Land site.

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.

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).

Excel For Mac Pivot Charts