Variable Width Chart in Excel not Working Properly

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

http://www.thepoorhouse.org.uk/oneclick_variable_width_column_charts_in_excel

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:)
varwidthcols.xlsm
Comment
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.

-SA

Author

Commented:
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