Results 1 to 8 of 8

Create multiple pivot charts from one pivot table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-25-2010
    Location
    Virginia
    MS-Off Ver
    Excel 2013
    Posts
    104

    Create multiple pivot charts from one pivot table

    Is it possible to create multiple charts from one pivot table - ideally without VBA?

    I found a response on another forum saying this was possible and describing the basic steps, but there was no sample data, and I can't get the steps to work with my data.

    Attached is a sample data file. My actual data can have about 10,000 to 50,000 rows.

    Each record represents an item being sold.

    This file has 3 worksheets. One sheet for data, one for the pivot table, and one where I'd like to put an assortment of graphs that get built from the pivot table data.

    Specifically, in the Charts worksheet, I'd like one chart that shows Total items sold by month.

    I would then like two more charts for Total items, one for the Total sold in the Region = AX2, and another chart for the Total sold in the Region = SCC. This is not all of the Regions, only 2 specific Regions of interest.

    Finally, still on this Charts worksheet, I'd also like one chart showing the Profit Score for all the Regions, and then two more charts showing the Profit Score for just my 2 high interest Regions of AX2 and SCC.

    Can someone help?
    Last edited by SueWithQuestion; 07-13-2011 at 12:29 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1