Chart for groupings

cjthorley · #1 04-09-2005, 05:51 PM

Dear Forum,

Im a beginner with EXCEL but I have a question about displaying groupings of values.

For example I have the following data:-

Label Cluster
M1 1
M2 3
M3 1
M4 2
M5 3
M6 3
M7 1
M8 1
M9 2
M10 3

Cluster Number in Each Cluster
1 4
2 2
3` 4

Basically I have results for a many thousand of Labels and the number of Clusters can be anything from 30 to 200.

Basically I want to show how the distribution changes across the cluster numbers. So I might want to visually compare 3 or 4 sets of data and choose the one that has a better distribution.

It would be nice to be able to see how many of each set have single values in their clusters.

Is there any chart that would be well suited to this kind of manipulation??

Thanks for you help in advance.

Regards

Chris

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)