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?
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks