Variable Width Chart in Excel not Working Properly

nirajkrishna used Ask the Experts™
I have created a variable width chart in Excel 2010 using the macro from the Poorhouse

And it works fine if I switch the volume and the price columns but I need price on the vertical axis.  I have attached my workbook. The bars do not look like bars like I want. They still have pointed tops. There is a macro in the workbook if anyone wants to help me out:)
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
My chartI've done a little playing around with this.  

Try dividing all your volume numbers by 10,000.  As an Area value it should be identical, but you'll find the chart looks like expected.



Nice work! Thanks for the help. I completely understand what you are saying about the scale:)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial