I would like to create a chart from an excell spreadsheet that has a projects IRR% along the Yaxis and the capital investment $ along the Xaxis and each bar in the chart to reperesent a different project. However, I'd like the width of each bar to equal the total dollar investment for its specific project. In other words, If Project A requires $20 million dollars of capital and has an internal rate of return equal to 18% and Project B requires $10 million dollars and has a rate of return equalt to 15%, I'd like the first basr in the chart to represent Project A and be twice as wide as the second bar in the chart representing project B. Each bar would extend up the Y axis equivilent to its respective IRR%.
Can this be done?
Can this be done?