+ Reply to Thread
Results 1 to 4 of 4

Two charts from one single Pivot Table

Hybrid View

mshtuhin Two charts from one single... 06-18-2012, 10:13 PM
MarvinP Re: Two charts from one... 06-18-2012, 10:59 PM
mshtuhin Re: Two charts from one... 06-19-2012, 11:06 AM
newbie_2011 Re: Two charts from one... 06-19-2012, 01:40 PM
  1. #1
    Registered User
    Join Date
    03-06-2009
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    51

    Two charts from one single Pivot Table

    Dear Experts,

    I have created two charts using same table. I did it by switching Row/Column.

    Now I want to do the same, i.e want two similar charts, but using pivot table. But while I m trying to switch row/column the pivot table automatically get changed!

    I want two charts from one Pivot table. i.e do not want pivot table get automatically changed.
    In other words, I want switch row/column in charts but do not want to get automatically switch row/column in pivot table.

    Attached is sample sheet, could you assist me please...

    thx
    Tuhin
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,281

    Re: Two charts from one single Pivot Table

    Hi Tuhin,

    I see your problem and have no good answer. I guess the answer is "that is how it works".

    Have you tried to make two separate Pivot Charts? Why can't you make two instead on only one?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-06-2009
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Two charts from one single Pivot Table

    Hi,

    My ultimate target is to get two separate pivot charts from a single pivot table. Not sure how to make it

    Anyway , many thanks for your reply

  4. #4
    Registered User
    Join Date
    06-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Two charts from one single Pivot Table

    If my understanding is right - you want two similiar charts from one pivot table.
    Here are the steps:
    1. create pivot table
    2. select the pivot table and insert the chart (any type of your choice).
    3. then select the same pivot table again
    4. Insert the chart again (as in step 2)

    This is how you can create 2 similiar charts from the same pivot table

    OR: Easy option:

    you can copy paste the first chart.

+ 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