Hello,
I am trying to figure out how to create a chart for each line of data on this excel document. I have attached the file with the first chart done manually as an example. I know that some players have more data than others, so if the chart's have some empty spaces on the x axis that is fine, but I would prefer that they do not. The example is at the bottom of sheet one. Sheet 2 is just a duplicate of the data in sheet 1 I messed something up. I am just looking for a quicker way to create individual line charts for each line of data, and then I will be copying and pasting each chart into word, and writing an analysis on each.
Ryan
PER-Number-Atlantic-and-Pacific.xlsx
See attached Workbook (working example) and sample output document as well as the code below
Open in new window
PER-Number-Atlantic-and-Pacific-v1.xlsmPlayerGraphs-Sample.docx