ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Best Way to Plot Graphs Clearly? (https://www.excelbanter.com/excel-programming/302837-best-way-plot-graphs-clearly.html)

Michael[_27_]

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

Fonda

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