Excel charting

I have some player stats from two different tournaments that I'd like to display on a chart.

The source is two blocks of data, one row per player, and then 3 columns of hitting data and 3 columns of additional data, both having an additional % column to the right, so :

Player 5 | 10 | 5 | 1 | 40% | 7 | 3 | 2 | 19.4%

etc.

I'd like to show a graph, perhaps per player, indicating their trending over time.
It's been a while since I've worked with charts, so I need some guidance, but I'm sure this can be accomplished very easily...thanks!
LVL 67
sirbountyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
1. select the data for one player, including labels for the legend
2. press F11 to make a chart on another sheet with that data
   OR click the chart wizard icon to have the option to make the chart on a new sheet
          or display the chart on the same sheet

once the chart is created,
right-click on a series and choose Format Data Seres
on Series Options, you can plot data on SECONDARY AXIS so you can have 2 scales.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sirbountyAuthor Commented:
F11 defaults to a bar chart, which may be okay,  However the series options shows the plot series on as disabled (for either primary or secondary).

These are two groupings from the start - do I need to select the first player and their data, and also the same info in the second table?
sirbountyAuthor Commented:
What I'm getting right now is a trend line with two lines for that one player.
Both icons for the legend show the player's number.  I'd rather show the date or tournament name for that label to trend on how they're improving over time...
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

sirbountyAuthor Commented:
I'd like to have one chart, but with 12 players and 6 tournaments, that may be too busy?
If I try to set this up for one player, the data formula appears like this:
='Aggregate'!$O$3:$V$4,'Aggregate'!$O$20:$V$20

When, I think, for me to copy/paste for each player, it should show this way:
='Aggregate'!$O3:$V4,'Aggregate'!$O20:$V20
??
sirbountyAuthor Commented:
And each time I try to copy/paste, which would be super easy, it resets my series label/formula...which is how I remember now why I dislike charting. :(
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you can edit the chart source in the formula bar too ~
sirbountyAuthor Commented:
Had to do a lot of manual adjustments to extend this, but it eventually led me to what I needed.  Thank you.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.