title: Using macros to format charts in excel
body: <p>I'm trying to create a macro that will format charts in Excel so that all of my charts have the same formatting, but different data. Usually I would just paste the formatting, but these charts were made using a plugin and they do not appear to be compatible with 'paste formats'. Each chart is in a different worksheet along with the chart data.</p>
  
  <p>My charts have 3 series. Each series has a particular format e.g. 
  series 1: circular marker, size-3pt, no marker line, green fill. 
  series 2: circular marker, size-3pt, black marker line, yellow fill. 
  series 3: circular marker, size-3pt, no marker line, red fill.</p>
  
  <p>Also, the charts need to be a specific size for presentation (no sure exact sizes yet, but presumably that should be easy to edit).</p>
  
  <p>These are the only parameters that I need to change from the default in order to get the charts to look how I want them. Can anyone help?</p>