Creating a Bar chart that doesn't sum??

[gissa]

Hello All -

I want to create a bar chart that, for several equity sectors (financials, consumer staples etc), the chart will illustrate the performance of 2 different baskets within the same sector. So, 2 metrics on one bar, each basket designated by a different color.

For example,
Financials:
Basket #1: +2.5% <----Blue
Basket #2: +3.5% <----Red

i want to illustrate this on one bar where the maximum value will be the larger of the two (3.5%). So, in this case, the blue part of the bar will populate from 0% - 2.5% and the red part from 2.5% to 3.5%.

Is this possible???

Thanks in advance!!

[robert111]

you need to convert your data as follows


2.5 / 6 *3.5
3.5 / 6 *3.5

then plot your stacked bar chart

the 6 is the sum of 2.5 and 3.5

adjust for different data values