Using Excel 2013 and looking for a way to automate creation of a Radar (or Spider) chart with custom labels for each tick mark on each axis of a chart.
I'm attempting to show a business' market activities relative to 4-5 market dimensions (Channel, Geography, Product/Service, etc). For example, the Geography dimension would have tick mark labels such as: North America, Europe, South America, Asia, Rest of World (ROW). I imagine each axis would continue to have a numerical value: North America = 1, Europe = 2, South America = 3, Asia = 4, Rest of World (ROW) = 5
Continuing with that example, on that axis a business might be valued at a 1 (active in North American market) or valued at a 3 (active in North American, European, and South American markets).
Any suggestions?
A good visual example is posted at:
https://farm8.staticflickr.com/7061/13702124765_000018af69_o.jpg
I'm attempting to show a business' market activities relative to 4-5 market dimensions (Channel, Geography, Product/Service, etc). For example, the Geography dimension would have tick mark labels such as: North America, Europe, South America, Asia, Rest of World (ROW). I imagine each axis would continue to have a numerical value: North America = 1, Europe = 2, South America = 3, Asia = 4, Rest of World (ROW) = 5
Continuing with that example, on that axis a business might be valued at a 1 (active in North American market) or valued at a 3 (active in North American, European, and South American markets).
Any suggestions?
A good visual example is posted at:
https://farm8.staticflickr.com/7061/13702124765_000018af69_o.jpg
