The parameters used in this UDf are :
- Points : range of values to be displayed - Mandatory
- LegendRange : range of cells containing the text to be displayed next to each segment - Optional
- Minimum : Value - Specifies the minimum value of the chart - Optional
- Maximum : Value - Specifies the maximum value of the chart - Optional
- ColorPositive : RGB color code for positive segments - Optional
- ColorNegative : RGB color code for negative segments - Optional
- Chart 1 from Net sales to Operating Profit
- Chart 2 from Operating Profit to Profit before tax
- Chart 3 from Profit before tax to Net profit
Successive charts share a commun value and identical scale (min and max values)
The chart is automatically drawn horizontally or vertically, and aligned with source values, according to the data layout.
I am however still not satisfied with the way the legend is handled.
The beta version of the add-in for XL2007 can be found here.
(again, if the file extension happens to be *.xlam.zip, just remove the ".zip")