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.

"joski" wrote:

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)

Thank you.
I had thought about that, but wasn't sure if I could use different scales
for each set of data...

"pdberger" wrote:

Joski --

You might want to try a 'radar' graph. It works well with values that are
unrelated to each other.

"joski" wrote:

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)

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/
_______


joski wrote:

Thank you.
I had thought about that, but wasn't sure if I could use different scales
for each set of data...

"pdberger" wrote:


Joski --

You might want to try a 'radar' graph. It works well with values that are
unrelated to each other.

"joski" wrote:


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)