add multiple(different) charts from on pivot table? RRS feed

  • Question

  • Is there any ways that I can add multiple (different) charts from on pivot table?

    I add more than one chart, from a single pivot table.

    1. But if I filter the data in one chart, every chart will get changed.

    2. I wanted to add one series on one chart, other series in other chart.

    Is it possible?

    What do you think?

    Monday, May 14, 2012 6:58 AM

All replies

  • Yes it is possible - you need to create two pivot tables from the same data connection, then create pivot charts from the pivot tables.

    Ed Ferrero

    Friday, May 18, 2012 7:12 AM