Home > Forum Home > Presenting and Reporting Data > Using list of options to present information graphically > Pivot table and pivot chart Share

Pivot table and pivot chart

Excel Help for Pivot Table And Pivot Chart in Presenting and Reporting Data

Forum TopicLogin

Pivot Table And Pivot Chart

Rate this:
(3/5 from 1 vote)
GratefulThere are several options for this. The easiest and most powerful would be to create a pivot table report of your data and accompanying pivot chart. In this case, you place the Job level at the page level filter and the Job titles and sectors in the row and column (either way depending on the analysis). The values can be set to count or if you have other numerical data then accordingly. Once the data is arranged appropriately, you can create a pivot chart from this. It will allow choosing of the Job level or sector (in the same way the pivot table has been set up).

Alternatively you could use some type of filtering on the data can apply the filter to the chart(s) source data; however making this dynamic may require some VBA code.
 Excel Business Forums Administrator
 Posted by on
View Full Post

Excel templates and solutions matched for Pivot table and pivot chart:

Solutions: Reorganize Data Pivot Table Formatting