title: Multiple Box Plots in a single chart using VBA Excel
body: <p>I have a set <a href="https://drive.google.com/file/d/0B7x4BoOdwK8TTVN0amY0Y01CNGc/view?usp=sharing" rel="nofollow noreferrer">data of gold price for the last 10 days</a> and I want to plot the data in form of candlesticks chart like this:</p>
  
  <p><img src="https://i.stack.imgur.com/kw7iJ.png" alt="enter image description here"></p>
  
  <p>but instead of using candlesticks, I want to represent the data each day using <a href="http://en.wikipedia.org/wiki/Box_plot" rel="nofollow noreferrer">box plot</a>, for example
  <img src="https://i.stack.imgur.com/uf03Q.png" alt="enter image description here"></p>
  
  <p>or like <a href="https://youtu.be/DrY50sH3SIE" rel="nofollow noreferrer">this video</a>.</p>
  
  <p>I want to use the following criteria in my new chart: x-axis is trading day and y-axis is gold price. So to speak, there will be 10 box plots in a single chart using the above data. My question is, what is the VBA program to create chart like that? I am new in VBA programming and I have tried to google this subject but nothing helps. Could someone here help me out? Any help would be greatly appreciated. Thanks.</p>