Can't find how to change Y-axis range to show new data in Excel Mac 12.2.4

[jjguroff]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a simple bar chart that I created some years ago in a previous version of Excel. I add data each month and it shows miles I drive per month over the year, very helpful to keep track of distance and gas mileage. I've extended the Y-axis range downward a few times before, but can't find out how to do it this time. I always install the latest updates from Microsoft and now I'm running Excel 2008 for Mac version 12.2.4 (100205). My Y-axis range in this chart starts at 800, but I drove only 772 miles in April. How can I adjust that range?

 

[John McGhie]

Use a named range as an argument in your SERIES statement. See here:

http://office.microsoft.com/en-us/excel/HA011098011033.aspx

Cheers

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I
have a simple bar chart that I created some years ago in a previous version of
Excel. I add data each month and it shows miles I drive per month over the
year, very helpful to keep track of distance and gas mileage. I've extended
the Y-axis range downward a few times before, but can't find out how to do it
this time. I always install the latest updates from Microsoft and now I'm
running Excel 2008 for Mac version 12.2.4 (100205). My Y-axis range in this
chart starts at 800, but I drove only 772 miles in April. How can I adjust
that range?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[jjguroff]

John, thank you for the quick reply with the link to what might be an answer. I realize now that I created my original chart in Excel Mac 2001, and what I'm trying to do now was super-easy before I went to the 2008 version. So, Microsoft introduced this really complicated stuff in 2003?? Hm-m-m-m. I'll need some time to go thru this article about the 2003 Windows version and see what I can do on my Mac ... I do appreciate your sending it, thanks!

 

[John McGhie]

No, it's the same technique you would have used in Office 98

It's just a named range: there's an alternative description here that uses
the OFFSET function to do the same thing:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Cheers

John, thank you for the quick reply with the link to what might be an answer.
I realize now that I created my original chart in Excel Mac 2001, and what I'm
trying to do now was super-easy before I went to the 2008 version. So,
Microsoft introduced this really complicated stuff in 2003?? Hm-m-m-m. I'll
need some time to go thru this article about the 2003 Windows version and see
what I can do on my Mac ... I do appreciate your sending it, thanks!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]