Best Way to Plot Graphs Clearly?
Hi,
Say I have a table liks this: TL APCSAL MHSDPA TSWR SOMM AOMM RRC ..814 .832 .521 1.0 .722 .954 .941 ..792 .819 .521 1.0 .684 .466 .941 ..814 .731 .521 1.0 .757 .638 .941 ..814 .832 .521 1.0 .220 .954 .941 ..814 .731 .285 1.0 .757 .323 .941 ..814 .731 .521 1.0 .722 .323 .941 ..814 .731 .285 1.0 .757 .323 .941 ..814 .731 .285 1.0 .220 .323 .632 ..814 .731 .521 1.0 .757 .638 .941 ..814 .832 .521 1.0 .757 .954 .941 ..814 .832 .521 1.0 .722 .323 .941 ..792 .819 .285 1.0 .757 .323 .941 ..814 .731 .521 1.0 .722 .323 .632 ..814 .832 1.0 1.0 .722 .638 .941 When I plot it using radar chart (Rows option), they don't look clear since lines cover each others! Is there a smarter way to make this clearer so each solution (each row is a solution) can be recognized easily (specially when you have many more rows)? Thanks, Mike |
Best Way to Plot Graphs Clearly?
Personally, I would've used a line chart, but it depends on the impact your looking for...
"Michael" wrote: Hi, Say I have a table liks this: TL APCSAL MHSDPA TSWR SOMM AOMM RRC ..814 .832 .521 1.0 .722 .954 .941 ..792 .819 .521 1.0 .684 .466 .941 ..814 .731 .521 1.0 .757 .638 .941 ..814 .832 .521 1.0 .220 .954 .941 ..814 .731 .285 1.0 .757 .323 .941 ..814 .731 .521 1.0 .722 .323 .941 ..814 .731 .285 1.0 .757 .323 .941 ..814 .731 .285 1.0 .220 .323 .632 ..814 .731 .521 1.0 .757 .638 .941 ..814 .832 .521 1.0 .757 .954 .941 ..814 .832 .521 1.0 .722 .323 .941 ..792 .819 .285 1.0 .757 .323 .941 ..814 .731 .521 1.0 .722 .323 .632 ..814 .832 1.0 1.0 .722 .638 .941 When I plot it using radar chart (Rows option), they don't look clear since lines cover each others! Is there a smarter way to make this clearer so each solution (each row is a solution) can be recognized easily (specially when you have many more rows)? Thanks, Mike |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com