data visualization

  • Thread starter Thread starter utefan001
  • Start date Start date
U

utefan001

Hi,
I have a 60k row worksheet that has three columns
company customer num_orders
Microsoft Maryland 150
Symantec Maryland 110

I want a chart to show that Microsoft and Symantec have a common
customer. For example a circle representing Maryland would connect to
two other circles representing Microsoft and Symantec. The 60k row
worksheet contains hundreds different companies and thousands of
different customers. If this cannot be done with Excel, does anyone
have a low cost software solution?

Thanks

Note to the cross posting police. This post can also be found in
microsoft.public.excel.charting, no answer there yet.
 
With hundreds of companies and thousands of customers, a chart would be a
mass of circles and points. How about something like a listing of customers
with all the companies associated with those customers? You can get that
with Data - Filter - Auto Filter (one customer at a time) of with a macro
producing the total list in one swack.
 
Back
Top