+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    07-19-2007
    Posts
    42

    How to create chart for Combinations of distinct categories

    heres what im trying to do; i have several series of data that represent different attributes that have all been assigned a weighted score of 1 through 5 (representing popularity). I am trying to chart these in order to pictorally show the strongest combination of them (maybe as an intersecting line or some plot on a radar chart). example
    Series 1: Color
    Red = 1
    Blue= 2
    Green =3
    Black= 4

    Series 2: Size
    Small = 1
    Medium = 2
    Large = 3

    Series 4: Font
    Arial= 1
    Times Roman = 4

    So i want these plotted somehow in order to show that the combination of Black/Large/Times Roman would be the most popular. Any ideas how to do this?

  2. #2
    "Eagle Eyed" Forum Moderator oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Work) and 2007 (Home)
    Posts
    7,130
    Hi,

    There a website here that may have the answer?

    http://peltiertech.com/Excel/Charts/SqueezeColumns.html

    There is a downloadable file on the website that shows you how to construct it. So using your data I attach my effort.
    Attached Files Attached Files
    oldchippy
    -------------


    If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

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.2.0