+ Reply to Thread
Results 1 to 2 of 2

Creating a panel chart within a pivot chart

  1. #1
    Registered User
    Join Date
    03-25-2020
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    3

    Creating a panel chart within a pivot chart

    Hello,

    I would like to create a pivot chart with multiple panels. I have attached my workbook that shows an example of this. I'd like to change the gridlines so they only appear for "Cost" and "Use" (so there would only be one vertical grid line between 2020 and 2014, instead of at each year).

    Under the thread "Create a bubble chart with sections" there is a link on how to create panel charts. In that example, if I'm not mistaken, the panel chart is created from first copying the pivot data as values. Is it possible to do something similar but within the pivot chart? I want to be able to incorporate the interactive capabilities of the pivot chart (such as adding in slicers etc.) so would rather not have to use a regular chart to do this.

    Any help would be much appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,836

    Re: Creating a panel chart within a pivot chart

    From Peltier's other panel chart tutorial, did you see this one? https://peltiertech.com/Excel/Charts...nelChart1.html It's old (2005 or so before Excel 2007 came out), but the same basic procedure seems to work for your pivot data as well. The basic procedure is to create a regular line chart from your pivot table (pay attention to this https://peltiertech.com/regular-char...-pivot-tables/ ). Then add a "dummy series" that will become the vertical dividing line between your categories.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

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