Anyone with Excel Charts experience?

[troller]

I am looking to create a chart of the data that exist for the Keno numbers and dates.

What I am trying to do is have the number show itself as a percentage of how well it did for a particular month.

I am at a loss of how to get it to do that in Excel. All the options are for the X axis. I tried using the stock chart but that is so confusing on which label to choose or which column should be what or is that a row I should be choosing..... I am unable to get it to work for me. It keeps giving an error everytime I select a column or a row of numbers. Weird.

Anyone know of how to do that? Create a chart showing the percentage of the particular number, of how well it is showing for a particular month.

* Numbers 1-70
* 12 Months (12 Charts or 12 months showing on one chart)
* Percentage 0-100%
- 100% being it showed everyday for 1 month.
- 50% would mean it showed for half the month.
- 0 % would mean that it did not show at all.
- And all other percentage values to show properly.

I think that the Y should be the percentage value and the X should be the numbers from 1-70. Again, the charts X value would reflect the percentage of how well it came in for a particular month. THis menthod would obviously need many charts for each number. Is there a way to show it like the stock chart?

If you know of a better way to get those numbers to reveal themselves according to the world of probability... please pass it on. For now I do not know of any program that can do that successfully.

I find that the human mind looking at a problem has way more analytical analysis, probability of outcome, figuring out the method to the madness... prowess then a computer program.

Not to say that the computer couldn't do it for me, just that there is no properly programmed programs out there that point out the obvious. Programs that do exist seem to be programmed to pick out random number combinations without any though of past or present trends. Give it a try. Bring up the results from yesterdays Keno draw, and compare what the computer program told you to pick. Now, if those numbers are close or off by one, then that's good, if not, and the majority is off by at least two numbers.... it fails to meet any standard to go by.

LottoSelector looked good... but it is way too finicky and crashes a lot. And the explanation of the numbers it is choosing is not basic enough for a typical person to comprehend. Not even close to picking out the obvious numbers that I am seeing on an Excel spreadsheet. Plus everyone out there has a different version, so no one really knows which version is best to use. v1 v2 v3? Even the website that you get it at seems like it has been forgotten.

 

[johnph77]

I've got a little experience, but I'm not, and never have been, a real fan of charts, preferring to look at the actual figures to make my analysis and form my conclusions.

The bar chart would be my choice here, not only for its ease of construction and readability, but for you to be able to witness the progress as it is constructed. Furthermore, it can be altered to form other types of charts (a line chart comes first and foremost to mind) if and when desired.

The single chart you're proposing would have 840 bars (70 numbers, 12 months) and would have to be placed on the vertical axis with horizontally extending bars. And this is easy to do in Excel. But this will be a large chart, larger than used in most visual applications.

The only real decision to be made is whether you wanted to separate the bars in the chart by months (12 distinct display divisions, 70 bars in each division) or by numbers (70 distinct display divisions, 12 bars in each division). And in actuality, if you want to replicate the entered data to create both types this is easily done. If you decide to make each division into a separate chart you'll be able to place vertical bars on a horizontal base, enabling you to create more readable line charts.

I use Excel 2002 and the online help for chart construction is fairly extensive. If it isn't sufficient you can purchase help manuals from any number of sources.

gl

john

 

[belwood123]

I have Excel experience....do you have or know where to get a complete, accurate list of the past winning numbers for Keno.

I would prefer the history of the draw.

With this data I can make some interesting charts.

I beleive there is more power in data manipulation than charting though.


Thanks,
Jeff

 

[troller]

Why not....

"If you want your friend to hear ya... you'll
have to talk a lot louder than that!"

I personally have gone to the sympatico lotto results page and copied all the months throughout the years into notepad. Save it... then open Excel and import the delimited data using spaces and viola... you have a great data source.

Personally I do not want to part with my own data considering all the time I spent on it. It's all color coded and there are a number of different views of the same data. Hard work I tell ya. Consistantly working on it day in and day out. Now if only I could sell my creation. I then could make some money to re-invest into making better more elaborate charts, possibly laminated for all to see.

Make me an offer.....