title: automatic graph generation in xlsx
body: <p>I wrote a script in R to do some analysis and make the result as a set of table in xlsx format.</p>
  
  <p>However, I would like to have some automatically generated default graphics from these tables in another sheet.</p>
  
  <p>one way is using</p>
  
  <pre><code>addPicture(file, sheet, scale=1, startRow=1, startColumn=1) 
  </code></pre>
  
  <p>from the xlsx package. meaning generating this plots using R and saving them separating and inserting them in to the excel file.</p>
  
  <p>I wonder, if there is any easier way, using excel functionality. For example if there is any formula for generating these plots to do so ?</p>
  
  <p>Basically, I wonder, if there is any automatic scripting way to generate these graphs ? is there any way, like a formula to do such a thing ?</p>