Any Excel nerds in here that are good with charts

[JasonGraham]

Lets say that I have 4-8 cells that have data in them as a percentage.

I want it to create a line graph chart showing the increase/decrease. I want to do that for every student in the school to show progress, or lack thereof, and export that (preferably) to a Word doc that i can email out or print.

Is there a way to do that quickly so that I don't have to do it manually for over 500 kiddos?

Something like create chart for cells b2:g2, export to Word, done.

[ayranton]

If you're using Google Sheets, there's an option to use Google Apps Script to automate the chart generation and export to Google Docs, which you can then easily download as a Word file.

[larisaguseeva]

What I’ve done in a similar situation is use Excel’s built-in chart features with a bit of automation. You can set up a template with dynamic ranges for each student, and then use a macro to generate the charts for each row of data. Once you have the charts, you can export them to Word pretty easily using Excel's "Copy as Picture" feature and paste them into Word.

I was in a similar spot last year, managing progress for a group of students, and it would’ve taken forever to do each chart manually. I found some great tips on https://excel.tv/ that helped me automate the process and save a lot of time.