title: how to create percentage bar chart in excel, similar to "100% stacked column" but with one variable against total value
body: <p>I thought over a lot for this case, I need to plot a series as percentage value of another series.</p>
  
  <p>e.g, series A is the capacity and B is the usage. I want a percentage plot of B on A. Initially I did this by creating a 100% stack chart with series B vs (A-B). I computed (A-B) on a separate column and used that as a series for this purpose. So far so good.</p>
  
  <p>But now I want to generate multiple charts like this (say 12 different graphs for 12 months' usage). I have 12 columns of usage data and one column of fixed capacity data.</p>
  
  <p>Is there a way to auto-generate this chart without having to create 12 intermediate columns with formula. It seems logical that Excel should have a chart type for representing A on B, just as they have one for A,B on A+B.</p>
  
  <p>Sorry if I am too lengthy or confusing in my description. I did my best here to explain.</p>