title: Excel chart showing wrong x-axis
body: <p>I have table from which I draw an X-Y scatter plot. The data is based on column B and column D. I want it to depict percentages on both axes. I have three similar tables, but for one of them my chart is not working correctly. I want the x-axis to show the correct percentage scale.</p>
  
  <p>I tried changing the column format between Percentage, Number and General. I tried creating a new figure from scratch.</p>
  
  <p>The results are shown in the picture below. Also, I want it to NOT show data points where the cells are BLANK but instead it shows as zero in my chart along the y-axis.<a href="https://i.stack.imgur.com/UdzaS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UdzaS.png" alt="enter image description here"></a></p>