+ Reply to Thread
Results 1 to 5 of 5

Data Comparison 2019 vs 2020 - How to create a Statistical Chart

  1. #1
    Registered User
    Join Date
    09-13-2019
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    22

    Data Comparison 2019 vs 2020 - How to create a Statistical Chart

    Good Afternoon,

    I would like to create a statistical analysis of the attached figures, separated by year and then bank and non bank. i.e.

    Bank 2019 vs 2020 All Countries (January to April 19/20)
    Mobile Bank 2019 vs 2020 All Countries(January to April 19/20)
    Non Bank 2019 vs 2020 All Countries (January to April 19/20)
    UK Non-bank 2019 vs 2020 (January to April 19/20)

    Could someone please help me figure out how to do this as I am not sure how to choose multiple pivot tables to create comprehensible charts

    Much appreciated!

    Regards,

    Marlon
    Attached Files Attached Files
    Last edited by marmar89; 04-16-2020 at 07:36 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,251

    Re: Data Comparison 2019 vs 2020 - How to create a Statistical Chart

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Registered User
    Join Date
    09-13-2019
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Data Comparison 2019 vs 2020 - How to create a Statistical Chart

    Hi Pepe,

    My apologies! I managed to find a workaround by myself How can I resolve the thread please?

    Thanks,

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,251

    Re: Data Comparison 2019 vs 2020 - How to create a Statistical Chart

    Please add the link as requested.
    And perhaps share your solution with the board?

  5. #5
    Registered User
    Join Date
    09-13-2019
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    22

    Re: Data Comparison 2019 vs 2020 - How to create a Statistical Chart

    Hi Phillip,

    Link: https://www.mrexcel.com/board/thread.../#post-5470238

    Workaround: create filters similar to the attached, and then go on Insert -> Pivot Table and from the right hand side under "Pivot Table Fields" you select the fields you would like to add/exclude to the report. One can also make use of the drag fields option within the PivotTable fields to determine where each field should be displayed.Attachment 678398

+ 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. Replies: 3
    Last Post: 01-28-2020, 02:14 PM
  2. [SOLVED] Correct exported date of 3/20/2019 to 3/1/2020
    By aquixano in forum Excel General
    Replies: 4
    Last Post: 09-20-2019, 11:32 AM
  3. Reflect TBF vacancies over 2018-2019/2019-2020 budget year
    By jennah63 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2019, 07:32 PM
  4. Stumped on how to create a horizontal line comparison chart
    By quaffin1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-25-2009, 08:39 AM
  5. [SOLVED] ow to create comparison chart using text as value data?
    By deejohn525 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-27-2006, 07:55 AM
  6. [SOLVED] How do I create a comparison chart from a data list?
    By comic guy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-19-2005, 10:05 AM
  7. [SOLVED] is there a way to create multiple pies in one chart (comparison)?
    By Jim W in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-14-2005, 10:05 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