Chart lots of names in a legible format?

Philip041

Board Regular
Joined
Jul 17, 2011
Messages
63
Hello there,

Hoping for some graphic representation advice..

I surveyed 100 people on their favourite company for 15 different types of investment. I need to be able to print this as a 'graph' on half a page. I would like to try and include the granularity that we achieved and not just lump it all together (ie. we want to show the top companies for equities, bonds etc.. not the top companies over all).

Is there a way to plot this (SmartArt?)? It can't be too fancy, the simpler the better, we're not graphic designers, we're financial analysts!

Many thanks!

Philip
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
How many companies are there ? 2 ? 3 ? 10 ? 1,000 ? That might influence how you present the data.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,536
Messages
5,469,266
Members
406,645
Latest member
jasondabsher

This Week's Hot Topics

Top