Excel charting

sirbounty
sirbounty used Ask the Experts™
on
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!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Remote Training and Programming
Top Expert 2015
Commented:
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.
Top Expert 2007

Author

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?
Top Expert 2007

Author

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...
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Top Expert 2007

Author

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
??
Top Expert 2007

Author

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 Programming
Top Expert 2015

Commented:
you can edit the chart source in the formula bar too ~
Top Expert 2007

Author

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 Programming
Top Expert 2015

Commented:
you're welcome ~ happy to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial