Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to plot 2 different graphs together | Charts and Charting in Excel | |||
Excel should be able to plot better probability graphs | Charts and Charting in Excel | |||
How-to not plot cells with zero value on graphs | Excel Discussion (Misc queries) | |||
Line Graphs - How do I plot N/As? | Charts and Charting in Excel | |||
How do I plot error bars on 3D graphs? | Charts and Charting in Excel |