Combo chart plotting $'s / % of total

[zagzebski]

I need to do a Combo chart.  Basically I want the bar to be "Amount" field and I want to line graph to plot the "Pct of Total".  I know having two expressions won't work and not sure how I have dollars for the bar chart and % for the line graph.

AR	Amount	Pct of Total
0-30	1000	48%
30-60	700	33%
60-90	300	14%
90+	100	5%

Thanks in advance,

Zag

[Anonymous · Accepted solution]

On the Axes tab of your Combo Chart for each expression you can set its position, so position one left and the other right and it will ok for one to be in $ and the other %

[zagzebski]

Thanks Bill.