Does Excel 2011 do Pivot Charts?

[zoziw]

Was doing some work in Excel 2011 and wanted to create a pivot chart...it was easy enough to do a pivot table but I was unable to find any way to do a pivot chart...I ended up doing a regular chart from the pivot table.

Does Excel 2011 do pivot charts?

 

[GGJstudios]

Was doing some work in Excel 2011 and wanted to create a pivot chart...it was easy enough to do a pivot table but I was unable to find any way to do. Pivot chart...I ended up doing a regular chart from the pivot table.

Does Excel 2011 do pivot charts?

MS Excel: Create a pivot table in Excel 2011 for Mac
via:

​

 

[zoziw]

MS Excel: Create a pivot table in Excel 2011 for Mac
via:

View attachment 314905​

I did that and got the same results...take a look at the results, they all involve pivot tables, not pivot charts.

 

[GGJstudios]

I did that and got the same results...take a look at the results, they all involve pivot tables, not pivot charts.

You're quite right. After adjusting the search terms to this:

​

I got this:

There still are some things the Windows version does that the Mac version doesn’t. These include pivot charts in Excel

 

[zoziw]

You're quite right. After adjusting the search terms to this:

View attachment 314907​

I got this:

Thanks for the help!

 

[exegete77]

Since I don’t have MS Office 2011, I have a question about the direction of this question. Does it have VBA? I know that 2008 did not.

But if VBA is supported, it is actually much stronger (and faster) to make Pivot Tables and Pivot Charts using VBA. I did that routinely using Office 2003 when I was working for a Fortune 100 company. I can give some links to follow if you are interested and if the Mac version supports VBA.

 

[GGJstudios]

Since I don’t have MS Office 2011, I have a question about the direction of this question. Does it have VBA?

Yep.

​

 

[zoziw]

Since I don’t have MS Office 2011, I have a question about the direction of this question. Does it have VBA? I know that 2008 did not.

But if VBA is supported, it is actually much stronger (and faster) to make Pivot Tables and Pivot Charts using VBA. I did that routinely using Office 2003 when I was working for a Fortune 100 company. I can give some links to follow if you are interested and if the Mac version supports VBA.

Yes they did; I'd be interested in those links you mentioned.

 

[exegete77]

Best overall site is MrExcel.com. (http://www.mrexcel.com/forum/index.php). I had participated for several years until I changed careers. Superb help from Excel masters in the world. Here are recent samples:

http://www.mrexcel.com/forum/showthread.php?t=588008&VBA+Pivot+Tables

http://www.mrexcel.com/forum/showthread.php?t=594397&VBA+Pivot+Tables

There is also a book that Bill Jelen (site owner) and others had written about VBA, and either chapter 11 or 12 was dedicated to VBA and constructing Pivot Tables (and then some corresponding work on how to set up charts in VBA based on the PT results). Can’t remember the specific title of the book, oh wait, here it is:VBA and Macros for MS Excel.

But also check VBAX (some of the best VBA programmers participate).

http://vbaexpress.com/forum/

 

[zoziw]

Best overall site is MrExcel.com. (http://www.mrexcel.com/forum/index.php). I had participated for several years until I changed careers. Superb help from Excel masters in the world. Here are recent samples:

http://www.mrexcel.com/forum/showthread.php?t=588008&VBA+Pivot+Tables

http://www.mrexcel.com/forum/showthread.php?t=594397&VBA+Pivot+Tables

There is also a book that Bill Jelen (site owner) and others had written about VBA, and either chapter 11 or 12 was dedicated to VBA and constructing Pivot Tables (and then some corresponding work on how to set up charts in VBA based on the PT results). Can’t remember the specific title of the book, oh wait, here it is:VBA and Macros for MS Excel.

But also check VBAX (some of the best VBA programmers participate).

http://vbaexpress.com/forum/

Thanks for the info on this!