Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 sets of data about 5 subjects (people) that I want to put into 1
chart. The dats sets are unrelated to each other & have different scales. I
am an Excel novice.Is it possible to plot the data on a circle divided into 5
sections for the subjects with each subject section divided into 5 for the 5
sets of data? (Excel 2003)
 
Joski --

You might want to try a 'radar' graph. It works well with values that are
unrelated to each other.
 
Thank you.
I had thought about that, but wasn't sure if I could use different scales
for each set of data...
 
The default radar charts don't allow this, but Tushar Mehta has a
variation on his web site which does. Look through the index down the
left of this page:

http://tushar-mehta.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top