title: Automate creation of charts in multiple excel files?
body: <p>I just spent a significant amount of time creating identical graphs in several dozen excel files (all containing identically formatted data,) and believe there has to be a more efficient way of completing what I've just done.</p>
  
  <p>To simplify things, consider 50 excel documents with data in the same format. <strong>Does there exist a method of automatically:</strong></p>
  
  <ul>
  <li>Creating a simple line graph</li>
  <li>Adding axis labels, a chart label, removing horizontal grid lines</li>
  <li>Including a trend line/R^2 value</li>
  <li>Saving the new workbook to a certain location with "_graphed" appended to the filename</li>
  </ul>
  
  <p>Would this be something that an Excel VBA could be used for?</p>