+ Reply to Thread
Results 1 to 3 of 3

Complex chart based on several categories and sub-categories

  1. #1
    Registered User
    Join Date
    02-09-2023
    Location
    Netherlands
    MS-Off Ver
    2019
    Posts
    4

    Complex chart based on several categories and sub-categories

    Hi all,

    I've attached a tryout file for you guys to understand my question.
    I'm trying to create multiple charts per Portfolio and Pots (which is a subcategory). Then I have static entries per year for that category and subcategory. This entry has a specific date that determines the Quarter in which the date belongs to.

    If you look in the Data per quarter sheet, you will see multimple entries of the same Portfolio and Pots specified per date and quarter.
    What I would like to have is an visual overview per portfolio in which the values AND differences per pot are presented per quarter.

    Any help is very much appriciated

    Tryout.xlsx

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Complex chart based on several categories and sub-categories

    Use PivotTable & Chart.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-09-2023
    Location
    Netherlands
    MS-Off Ver
    2019
    Posts
    4

    Re: Complex chart based on several categories and sub-categories

    Josephteh! Thank you so much for the help. Going to analyze your work and again thanks for the support

+ 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. [SOLVED] Need sum total of categories per interval based on agent schedules and their categories
    By cph020283 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2021, 05:21 PM
  2. Data Validation from another Workbook (categories and sub categories)
    By pingoui in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-07-2019, 04:59 AM
  3. Coloring Radar Chart based on categories and segments
    By brissyb in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-03-2018, 04:45 AM
  4. Chart from Categories with Sub-Categories
    By Chris Nolen in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-06-2017, 09:49 AM
  5. Replies: 1
    Last Post: 05-15-2013, 06:55 AM
  6. Replies: 0
    Last Post: 07-22-2011, 03:51 PM
  7. Replies: 6
    Last Post: 08-18-2009, 11:04 PM

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