How to setup a graph from multiple data sets into a single display

If there are any Excel experts out there that can provide any help, I would really appreciate it...I've been searching for an answer for a couple of months now, but apparently looking in all the wrong places....

Anyway, I'm trying to graphically represent a line of profitability by combining the results from two ratios.

RATIO's.
Success ration (# successful trades / total trades)
Win/Loss Ratio (average win size / Average loss Size)

I've got the data in a table but would like to setup a graph that can clearly illustrate where the best combinations are. I've attached a copy of the worksheet for review...

Unmerge B2:C2 and make a surface chart.

Is the lower plot what you had in mind?

That worked, thank you, thank you, thank you....learned something good....

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

Excel surface charts have very little flexibility -- I don't think you can. But Andy Pope would know for sure.

The grid lines are being covered by the fill of the surface chart.

In the attached I have set the fill colour of one of the bands to none.
You can see the 2 majoe gridline sets through the gap.

The gridlines over the surface are controlled by the individual legend entries

riaz_453,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.