How to make collapsible columns for a table?

In Excel 2010, using an existing Pivot Table, how do I make a chart based on specific columns only?

  • When I try to make a chart based on a pivot chart, it keeps including all the columns in the pivot chart. I only want to use a couple columns not the whole thing, and I cannot figure out how to do this.

  • Answer:

    Check only the boxes you require - leave the rest unchecked and it should work.

Retrofan at Yahoo! Answers Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.