+ Reply to Thread
Results 1 to 2 of 2

Make charts of combinations of labels (column B) related to subjects (column A)

  1. #1
    Registered User
    Join Date
    03-29-2020
    Location
    The Netherlands
    MS-Off Ver
    2013
    Posts
    1

    Make charts of combinations of labels (column B) related to subjects (column A)

    Hello from the Netherlands,

    I hope you can help me with the following problem I would like to solve:

    Every week I receive an Excel datafile that looks like the one in the attachment (but much more elaborate - more than 2000 subject and about 200 different labels). It only exists of two columns, a subject-column and a label-column. As you can see in the example, some labels are related with more then one subject, and most of the subjects are related with more labels.

    From these two columns I would really like to make some charts. What I would like are some charts where the relationship between a combination of labels (from the label-column) and the amount of subjects where this combination exists is being shown. For example there are 65 subjects with combination Label1 AND Label2 en 32 with combination Label1 AND Label4. But I would like to provide insight of all possible combinations (I won't show them all, but I'd like the opportunity to choose it).

    It's my goal to create weekly a kind of dashboard (with Power Pivot/View)? with for example six or eight charts where I give insight in some relationships between (combinations of) labels and subjects.

    Can you give me some advise of the easiest way to handle this?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Make charts of combinations of labels (column B) related to subjects (column A)

    Crosspost https://www.helpmij.nl/forum/showthr...lateerd-kolomA

+ 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: 7
    Last Post: 09-28-2017, 04:19 PM
  2. How to make evolutions in pivot table with multiple column labels
    By elmister in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-26-2015, 10:36 AM
  3. Suppressing zero values AND column axis labels in Bar charts
    By 4michaelmay in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-04-2014, 11:33 AM
  4. Replies: 11
    Last Post: 06-03-2013, 11:52 AM
  5. Replies: 6
    Last Post: 05-17-2010, 08:26 AM
  6. Make Labels on Charts Uniform Size
    By cpadude in forum Excel General
    Replies: 0
    Last Post: 04-23-2007, 11:31 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