0

I have an Excel Line Chart which looks like this:

enter image description here

The series has values only from 275 to 500. But the chart is showing axis from 0 to 600. I want the chart to adjust the size according to the series values. Something like this should only be shown:

enter image description here

How can I do this?

Improve this question
1
  • 1
    Right-click on the Y axis to access the formatting settings. Set the minimum value to what you want.
    – fixer1234
    Commented Apr 21, 2019 at 7:27

1 Answer 1

Reset to default
0

Right Click Y Axis- Select Format Axis...- Under Axis options change Bounds and Units values:

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .