I want to have a stacked column chart with one column of data with 4 items. Each item has two measures associated with it, say a percentage of total and a dollar value.
For example,
Item % $
A 42% $15.00
B 33% $12.00
C 14% $5.00
D 11% $4.00
Is it possible to show the 4 items in a stacked column, with each item appearing once. The chart's left axis would have percentage labels (totaling 100%) and the right axis would have dollar labels (totaling $36).