title: Hiding empty values in bar plot in Excel
body: <p>How can I hide the x-axis and at the same time shrink the chart where there are no values? The idea is that the chart will expand and shrink depending on the value inputs. </p>
  
  <p><a href="https://i.stack.imgur.com/LDJpO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LDJpO.jpg" alt="enter image description here"></a></p>
  
  <p>I want the expected chart will look like this even though the chart will select rows way beyond what is shown:</p>
  
  <p><a href="https://i.stack.imgur.com/RF3Ms.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RF3Ms.jpg" alt="enter image description here"></a></p>
  
  <p>Is this possible? I have tried many options without success.</p>