Hey! is there any Excel expert who can solve this…..? are u here Mr VBAXLMAN..?.?
i would like to create a line chart in ms excel….where “runs” will be ploted in y axis, or vertical axis and “overs” in horizontal axis….
runs will ploted in 50 runs interval and overs will be in 10 overs interval….u might have seen this in cricket…
wait …..it’s not so easy one….i’ve a few conditions
1) the resultant line will be displayed in a single line,,,,i repeat ..in a single line….as u would have noticed in cricket score analysis.
2)it will start from the (0,0) point…that means 0 run at 0 over…
and will travel with the increasing runs and respected overs…(as it is made in graph papers.)
3)i’m using msexcel 2002….so pls solve it in 2002 or older….
i think i’ve expressed it enough….
if u ‘ve done it then try this for two teams for there score analysis …..obviously there will two seperate line for two teams , say India & Pakistan or Australia & NewZealand…
every good answer will get a thumbs up and the best answer ……u know better
hey! Mr here 2 help…..
it’s not my home work……try to sove it….it’s a bouncer….so, dont play a hook shot….play defensive…if u r a good batsmant then drive it and get a boundary
and for ur information i’m not a school boy…
sorry, i’ve done two spelling mistakes in hurry…….it would be “solve” and “their” instead of “sove” and “there” respectively.
oh! yes.. i would like to add this…….i’ve asked this same to so many people ……nobody could give me the answer…..so dont take it easy…..it’s time for ur homework..
Players Club Tours answers:
I got your e-mail.
The solution is all in the table that you will create for it
Wherever hard you think the chart is, the solution is in the table
Excel charts are created from tables, means that you can not (Never) create a chart without its data.
So we are (You and me) have to see how to build the table that will represent the chart
I can’t e-mail you through Yahoo, you have not confirmed your e-mail there…
Send me your e-mail address, I can not e-mail you
Enjoy my profile, I am the VBAXLMan
Powered by Yahoo! Answers