title: Multiplication of a constant on raw data while creating a graph in Excel
body: <p>I'm intending to create a graph which purpose is to give a visual understanding of how different costs changes depending on production volumes. However the costs are expressed in USD, while the production is expressed in tonnes. This causes the line representing the production to appear to be "flat" across the x-axis. I therefor want to change the production unit to be kilograms instead of tonnes to "normalize" the lines to have similar values, thus enabling a much clearer basis of comparison between the costs and production.</p>
  
  <p>I have my production volumes and costs represented in a worksheet. Is there a way to represent the production volumes in the graph in kilograms instead of tonnes without needing to:</p>
  
  <pre><code> 1) Multiply the production volumes by 1000 in the worksheet itself? or
   2) Add additional data multiplied by a 1000 which is hidden?
  </code></pre>
  
  <p>The constraints 1) and 2) is due to having so much data to adjust.</p>
  
  <p>EDIT: What I've tried is to add an additional y-axis for the production making it to be a histogram to make it different from the costs represented by lines, but it doesn't look that great.</p>
  
  <p>Also, I've tried to click on the line in the graph to see:</p>
  
  <pre><code> =SERIES(Indata!$A$15;Indata!$C$2:$DR$2;Indata!$C$15:$DR$15;4)
  </code></pre>
  
  <p>and added "*1000" in the back. It gave me error. </p>
  
  <p>Also, trying to edit the data and add "*1000" with error too. </p>