Combo Chart

[Anonymous]

Hi Everyone,

I am trying to create a Combo chart as per the attachment.

I have managed to do the bar part of the graph but struggling with the % line part.

The % is worked out by taking the overall total and dividing by the individual results.  I would like the graph to change with each different selection.

Please could anyone advise how I would do this.

Many Thanks

Kind Regards

Wendy

[swuehl]

Hi Wendy,

it would be easier to answer if you actually could post the expressions and dimensions you are using, instead of a screenshot. Or even better, if you could post a small sample QVW.

In general, it should look like

=Num( Sum(Value) / Sum(TOTAL Value), '#.00%','.',',')

edit:

.. but your percentage numbers seem much too high to show part of the total

[Anonymous]

Hi swuehl,

Thank you for your response.  That has helped me but now I am having trouble getting the Axis correct for my % part of the chart.  They are not big enough and I am not sure how to increase and decrease them.

Would you be able to point me in the right direction?

Many Thanks

Kind Regards

Wendy

[swuehl]

You can set your percentage values to a second y-axis, go to Axes tab, select your percentage expression and select 'Position Right (Top)'.