How to change displayed y-axis range?

LisaP · #1 10-31-2019, 08:40 AM

Hello, attached is a screenshot of a graph I made in Excel. As you can see, the y-axis is scaled from 1.9 to 2.7 so the difference between the two bars is substantial. This distorts the reality, however - if the y-axis were scaled from 0 to 2.7, the bars would be much closer in length. How do I change this? And why did it create it this way (i.e. did I do something wrong when creating the graph)? Thanks in advance for any advice out there!

jeffreybrown · #2 10-31-2019, 03:34 PM

Hi Lisa,

Right click the vertical axis and format the axis. You can set a minimum and/or a maximum.

LisaP · #3 11-01-2019, 05:03 AM

Thank you!!! I sent SO much time searching in the Excel Help sections.....I don't know why I couldn't find this info. Now that I know, it does seem intuitive! :-P

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using a Checkbox to Change Content that is displayed	noldak	Word VBA	1	08-31-2017 04:53 AM
Change Y axis #'s from ascending to descending?	markg2	Excel	3	04-11-2017 04:48 AM
I would like to change how the screen is displayed	ottiliegirl	OneNote	0	01-17-2016 10:27 AM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010	sharath_ms	PowerPoint	0	07-08-2013 10:06 PM
Change the time displayed in the Calendar	holland	Outlook	0	02-08-2012 05:34 AM