<div>
F11 defaults to a bar chart, which may be okay, &nbsp;However the series options shows the plot series on as disabled (for either primary or secondary).<br />
<br />
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?
</div>


<div>
What I'm getting right now is a trend line with two lines for that one player.<br />
Both icons for the legend show the player's number. &nbsp;I'd rather show the date or tournament name for that label to trend on how they're improving over time...
</div>


<div>
I'd like to have one chart, but with 12 players and 6 tournaments, that may be too busy?<br />
If I try to set this up for one player, the data formula appears like this:<br />
='Aggregate'!$O$3:$V$4,'Ag<wbr />gregate'!$<wbr />O$20:$V$20<wbr /><br />
<br />
When, I think, for me to copy/paste for each player, it should show this way:<br />
='Aggregate'!$O3:$V4,'Aggr<wbr />egate'!$O2<wbr />0:$V20<br />
??
</div>


<div>
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. :(
</div>


<div>
you can edit the chart source in the formula bar too ~
</div>


<div>
Had to do a lot of manual adjustments to extend this, but it eventually led me to what I needed. &nbsp;Thank you.
</div>


<div>
you're welcome ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
I have some player stats from two different tournaments that I'd like to display on a chart.<br />
<br />
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 :<br />
<br />
Player 5 | 10 | 5 | 1 | 40% | 7 | 3 | 2 | 19.4%<br />
<br />
etc.<br />
<br />
I'd like to show a graph, perhaps per player, indicating their trending over time.<br />
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!
</div>
</div>


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!

Excel charting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.