+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    02-26-2007
    Posts
    22

    Impossible Graph?

    Hi all, I am trying to figure out how to do an industry analysis type graph. Ill try to explain it as best as I can.

    There is a list of companies. For each company there is a value for each of the following: Net Income, Revenue, Cost of Goods Sold, Operating Expenses, and Other Expenses.

    Graph format: I need each company to be a plot (point) on a graph where the x-axis is the net income and the y-axis is the revenue. The plot will be represented by a pie graph, with each of the company characteristics being a slice. Also, the pie graph must be sized relative to the other companies' pie graphs based on Revenue.

    I'm not sure that this can be done in Excel, but if anyone can help me out, it would be greatly appreciated. This seems like a problem that an excel master might enjoy fiddling around with.

    ****Attachment has data and a rough picture of what im looking for. ***
    Attached Files Attached Files

  2. #2
    Forum Guru Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,999
    Hi,

    Andy has already solved this kind of chart problem ...
    see his solution ...
    http://www.andypope.info/charts/piesizer.htm
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    02-26-2007
    Posts
    22
    Awesome, thanx for pointing that out.
    Last edited by walke2jd; 02-26-2007 at 04:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0