Set automatic axis limits for bar chart without defaulting to zero

Set automatic axis limits for bar chart without defaulting to zero I am building a bar chart in Excel with data values ranging from, e.g., 10 to 20. I want the x-axis limits to be automatic, but although the right limit (near 20) works correctly, the left limit always defaults to 0.
Asked by: Guest \| Views: 246

Total answers/comments: 1

Comments display order:

Guest [Entry]

"I don't think it can be done without making it Fixed. You cannot change the results of Auto value since it is using a built-in algorithm of Excel. For those who would like to know how to change the Fixed values:

Click on the X axis, then right-click and select Format Axis. On the Axis Options tab, change the Maximum and Minimum values from Auto to desired Fixed values."