graphing ...on primary/secondary axis (issue)

[bluepenink]

hello all

struggling with a basically graphing need.

i need to show the actual align with the percentage....

so if budgeted is 8000$ and actual is 4000$, then its 50%

so graph should be on primary and secondary axis, 4000 ($) and 50% respectively and should be graphed accordingly....how can i set this up so both the $ and % coorelate to each other?

can someone pls advise...been at this for over a day, pls and thxs

 

[Jon Peltier]

Set the range of the percentage axis to 0%-100%, and the range of the dollar axis to $0 to whatever dollar value represents 100% (in this case $8000).