#1   Report Post  
utefan001
 
Posts: n/a
Default data visualization

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

I want the 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

  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Ummm...with 60,000 records it is hard to imagine any visualization
scheme that would be effective unless you reduce the space over which
the visual effect applies.

Luckily, your data are perfectly organized to use one of XL's filter
capabilities -- autofilter (Data | Filter AutoFilter). Once you
enable auto filter, select the dropdown arrow at the top of the
customer column, pick a specific customer and XL will restrict the
display to its vendors. You can do something similar with a vendor
wherein you select a vendor and XL will restrict the display to all its
customers.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

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

I want the 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pull Current Month's Data Out of List - Repost Karl Burrows Excel Discussion (Misc queries) 4 May 3rd 05 01:06 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 03:45 AM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"