How to chart a large series of numbers

**pjw23** · 03-23-2009, 11:39 PM

I'm using Excel 2007 and trying to graphically represent a large series of numbers to get a good visual representaion of the data.

Column C - Win/Loss Ratio W/L - (.05 - 5.0)
Row 3 - Batting Average BA - (1% - 100%)

_______1% 2% 3% 4%
___.05
___.10
___.15

Formula for 1st data point (Data represented - 1% BA; .05 W/L)
=((($C4)*(D$3*100))+(($C4-1)*(100-(D$3*100))))

This table results in a wide range of numbers with multiple price series.

Question:
What is the best graph type to use?
How can I clean it up to make it easily readable?

**Andy Pope** · 03-24-2009, 08:39 AM

What information are your trying to get from the chart?

Can you post example workbook of what you currently have

**pjw23** · 03-24-2009, 04:45 PM

Originally Posted by Andy Pope

What information are your trying to get from the chart?

Can you post example workbook of what you currently have

Thanks for the reply. The two ratio's (batting Average, Win/Loss ratio) are the foundation of my trading business. My intention is to take the data from the table I created and represent it in a graphical format so that I can visually understand where the best combinations are for the two ratios in order to achieve maximum profitability. By understanding this I can adjust my different strategies around these numbers. So to answer your question.

1. I'm trying to understand how batting average relates to win/loss ratio as it pertains to profitability.

2.) I'm not sure how to post an example workbook. But based on my orignial post batting average starts at 1% in cell D3 and goes accross. Win/loss starts at .05 in cell C4 and goes down. In Cell D4 I have the formula: =((($C4)*(D$3*100))+(($C4-1)*(100-(D$3*100))))

Thanks again for all of your help, I hope this is information can better explain what I'm trying to figure out.