Hi Jonas,
Thanks for your reply.
I cannot make your code so that it change the column width.
The graph I have the columns amount represent the profit and I am using the offset left and right % to set the column's width based on the volume of sales.
I know how to do this manually but I like to write a macro to have it automated. With the code you provided the coloum width is not changing. I have played with the value for the textureOffsetX, .TextureOffsetY, TextureHorizontalScale and TextureVerticalScale but still the column width stay unchanged.
will it help if I send you a copy of my file ?
Regards,
Alain