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. ***
Hi,
Andy has already solved this kind of chart problem ...
see his solution ...
http://www.andypope.info/charts/piesizer.htm
Awesome, thanx for pointing that out.
Last edited by walke2jd; 02-26-2007 at 04:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks