Stephan
Member
Hello, see attached file, all main chart types from same yes/no data table, presenting more valid alternatives then Radar chart for demonstrating trends/majoritites.
Further to FB evo RADAR chart debate, ie can you do that in Excel, yes but they are less sophisticed, and as many have pointed out Excel Radar charts are ineffective data visualisations.
Think alot of confusion is what does data table look like, well its a YES NO table with categories. Hence table with numerous Y characters, but Y isn't recognised by Excel, hence changed Y value > 1 value. In other words instead of letter character, this is replaced with numeric 1 value to demonstrate its a YES!
Data table: 1st tab Bar Vert, Range: A25:L30. Presumably data would have been demonstrated differently for decision factor, see last tab Sheet Y Grid H & V, Range: A1:BD3.
Presumably data was stacked to make differences more obvious, Sheet Y Grid H & V, Range: A5:L10.
H = Horizontal, V = Vertical.
File attached is several different chart types from YES/NO table data, personnely I think the most effective at demonstrating is in following order, considering compelling to look at that doesn't require too much thought, but looks more appealing then basic chart:
Surface 3D > Area 3D > Area > Bar Vert > Bar Horiz > Pyramid.
I'd say Excel 2003 Radar or Donuts charts for this dataset are useless, apart from demonstrating what is majority, as overlaps everything else.
But if somebody has emulated the source FB evo radar charts or the infographic political chart but done this in Excel2003 with formula, I'd love to see that.
Further to FB evo RADAR chart debate, ie can you do that in Excel, yes but they are less sophisticed, and as many have pointed out Excel Radar charts are ineffective data visualisations.
Think alot of confusion is what does data table look like, well its a YES NO table with categories. Hence table with numerous Y characters, but Y isn't recognised by Excel, hence changed Y value > 1 value. In other words instead of letter character, this is replaced with numeric 1 value to demonstrate its a YES!
Data table: 1st tab Bar Vert, Range: A25:L30. Presumably data would have been demonstrated differently for decision factor, see last tab Sheet Y Grid H & V, Range: A1:BD3.
Presumably data was stacked to make differences more obvious, Sheet Y Grid H & V, Range: A5:L10.
H = Horizontal, V = Vertical.
File attached is several different chart types from YES/NO table data, personnely I think the most effective at demonstrating is in following order, considering compelling to look at that doesn't require too much thought, but looks more appealing then basic chart:
Surface 3D > Area 3D > Area > Bar Vert > Bar Horiz > Pyramid.
I'd say Excel 2003 Radar or Donuts charts for this dataset are useless, apart from demonstrating what is majority, as overlaps everything else.
But if somebody has emulated the source FB evo radar charts or the infographic political chart but done this in Excel2003 with formula, I'd love to see that.