i am using a Mekko chart to display the values ,is it possible to set size of block through properties or by the VB script.
I want to display all the values in equal size blocks irrespective of data values.
Suggest me if we have any other options as well.
Why can't you use the pivot table
I don't think you will get equal size blocks.
or you can use the list box and the logic for your calculation can be your expression in the list box
Please see the image below
Retrieving data ...