+ Reply to Thread
Results 1 to 6 of 6

Combine two pivot charts into one

  1. #1
    Registered User
    Join Date
    10-05-2020
    Location
    Madeira Island
    MS-Off Ver
    365
    Posts
    3

    Question Combine two pivot charts into one

    Hey guys,

    I have this table where I have a column saying "Year or Purchase" and another column "Year of Selling".
    How can I combine these 2 columns into a single row in a chart showing each year, and have in the chart two columns for each year showing how many I have bought in that year, and showing how many I have bought in that same year.

    Basically, it would combine these two charts that I have, where in the year 2011 I would only have 28 purchases and no sells, in 2012 I would have 97 purchases and 6 sells, and so on.

    I appreciate your help.

    Luís M.

    Screenshot_1.png
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Combine two pivot charts into one

    Hello luismsr and Welcome to Excel Forum.
    It may help someone propose a solution if we could see an .xlsx file (instructions for uploading are in the banner at the top of the page) that shows source data as well as the pivot tables and charts.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    10-05-2020
    Location
    Madeira Island
    MS-Off Ver
    365
    Posts
    3

    Re: Combine two pivot charts into one

    Hey,
    Thank you for your reply.

    I have attached an edited copy. As you can see, there is a column with year of purchase, and another column with the year of selling.
    In the other tab on the file, there are the graphs showing those results, but separated as I have shown before.

    I want them to be on the same graph, in a single row for each year containing 2 columns. If possible

    Thank you.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Combine two pivot charts into one

    As neither the ano compra nor ano venda columns contains all of the years, I feel that one of the simpler ways to produce the graph is to use formulas.
    1. Place a list of years, 2011:2020 in column A
    2. Populate column B using: =COUNTIFS(Coleção[Ano Compra],A2)
    3. Populate column C using: =COUNTIFS(Coleção[Ano Venda],A2)
    4. Produce a column graph
    Let us know if you have any questions.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-05-2020
    Location
    Madeira Island
    MS-Off Ver
    365
    Posts
    3
    That's a great solution, thanks.
    The only problem is that the column year in that new table doesn't populate automatically. But that's okay 🙂

    Have a great week!

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Combine two pivot charts into one

    You're Welcome and thank you for the feedback. I hope that you have a blessed day.

+ 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. Need non-overlapping Stacked Column charts in pivot charts
    By chand173 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-13-2018, 02:08 PM
  2. [SOLVED] Vary Colors in Pivot Charts based on values (Overlay Charts)
    By TitansGo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-18-2017, 04:36 PM
  3. Pivot charts - how to filter data in charts
    By eeinkee in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:48 AM
  4. Replies: 3
    Last Post: 04-01-2016, 01:09 AM
  5. Combine two pivot charts into one chart?
    By rbot in forum Excel General
    Replies: 0
    Last Post: 09-12-2011, 11:08 AM
  6. Creating simple charts from multiple pivot table charts
    By hovaucf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2008, 04:13 PM
  7. Replies: 0
    Last Post: 01-19-2005, 06:34 AM

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