Stack chart with $$ Yaxis and Comp. Rate % on bar

[karensmith]

Trying to replicate this Excel stack chart in QV. Values on bars are Compositon Rate$ and Y axis is total sales value for MMYYYY.

Is this possible in th QV? I can create this chart in QV, but Y axis is displays % for composition rate. I can't figure out how to display sales value $$$.

.

[#2]

Hi Karen,

I think you can get close. Use a combo chart.

On the 'style' tab, set your bar style to stacked.

Create your set of measures in terms of dollars, and set all of their displays to 'bar' only.

Create a second set of measures performing your relative calculation to express them as percentages, and set them all to 'line' only display, set 'values on data points', and set the 'invisible' box at the top. (the lines will be invisible, but the data point labels will remain); On the axis tab, set all of you line (%) measures to be on the 'right' axis, and hide it. (setting the 'hide axis' check box)

I think that should get you in the neighborhood.