+ Reply to Thread
Results 1 to 2 of 2

splitting pivot chart

  1. #1
    Registered User
    Join Date
    04-12-2024
    Location
    UK
    MS-Off Ver
    365
    Posts
    3

    Question splitting pivot chart

    Hello All,

    i'm trying to create 'unusual' pivot chart in my opinion. its kinda hard to describe what i need. so below is picture of an original chart i was able to create, and a chart i would like to get. Basically i need to split each section into smaller charts. does anyone know if this is even possible?
    ss2.jpg

  2. #2
    Registered User
    Join Date
    02-29-2024
    Location
    EGYPT - Cairo
    MS-Off Ver
    MS365
    Posts
    91

    Re: splitting pivot chart

    Hi nastslay,
    Welcome to the forum.
    If all the info is still in the same pivot table, you just create several copies of that pivot table and adjust each one according to the desired results. Then create the pivot chart for each pivot table and you can collect all of them in something like a dashboard. Or even add a slicer and make sure that it is connected to all your pivots and this way you can create many tiny charts as much as you want.
    If it is still not clear, just upload a sample file to show you an example.
    Thank,
    Mohamed GadAllah

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Splitting data in a bubble scatter chart
    By Leon V (AW) in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-12-2022, 08:26 PM
  2. Splitting a pivot table into two
    By JRDavie in forum Excel General
    Replies: 6
    Last Post: 07-23-2021, 10:36 AM
  3. Pivot Splitting tools
    By tommyantonius in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2019, 12:42 AM
  4. Replies: 3
    Last Post: 04-01-2016, 01:09 AM
  5. pivot table splitting different colums with same value
    By teddy1987 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-23-2015, 02:21 PM
  6. [SOLVED] Chart Combo - Splitting X axis
    By Grat in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-31-2012, 09:58 AM
  7. [SOLVED] Splitting Y-Axis into 2 for a line chart
    By Jason in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-02-2005, 02:06 AM

Tags for this Thread

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