Hi, in the attached I wanted the axis scale to adjust and take 22.5% rather that 23.57% on the axis which doesn't look right. I can't work out how to change this.
regards
Stephen
Hi, in the attached I wanted the axis scale to adjust and take 22.5% rather that 23.57% on the axis which doesn't look right. I can't work out how to change this.
regards
Stephen
It's not clear to me what needs to change.
I notice that you are using a line chart with a text/category axis. My first guess at what you want is that you want an XY scatter chart so that the values in row 7 are treated as numbers in the chart rather than text categories. Is that what you are looking for?
Originally Posted by shg
Let change chart type to Scatter chart, set Axis Option in Bounds and Unit, and change format number.
Visit my YouTube channel Excel NaNa
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks