Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-08-2017, 03:49 PM
markg2 markg2 is offline Change Y axis #'s from ascending to descending? Windows 7 64bit Change Y axis #'s from ascending to descending? Office 2016
Expert
Change Y axis #'s from ascending to descending?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default Change Y axis #'s from ascending to descending?

The Y axis bounds are min 0, max 10. 0 is currently at the Y axis bottom (x,y intersection).



As the linked table values increase, the plot moves up and right.

I would prefer the inverse. 10 at the bottom, 0 at the top of the Y axis. This would allow for increasing table numbers to move the graph down and right.

I tried manually switching the Bounds 0 to 10 and 10 to 0 thinking that would result in the Y axis starting with 0 at the bottom and 10 at the top.

I can't even describe how badly that maneuver screwed up the graph.

How do I achieve inverting the order of the Y axis?

Mark
Reply With Quote
  #2  
Old 04-08-2017, 04:05 PM
jeffreybrown jeffreybrown is offline Change Y axis #'s from ascending to descending? Windows Vista Change Y axis #'s from ascending to descending? Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Once you right click on on the Y-Axis and select >> Format Axis...

Did you try >> values in reverse order...
Reply With Quote
  #3  
Old 04-09-2017, 09:35 AM
markg2 markg2 is offline Change Y axis #'s from ascending to descending? Windows 7 64bit Change Y axis #'s from ascending to descending? Office 2016
Expert
Change Y axis #'s from ascending to descending?
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

Clearly, no. I was totally focused on Bounds. Of course invert worked. Thanks (all) for the patience with tedious questions.

Here are (I hope) my last questions on the graph.

My object is to insert ‘callout’ text structures pinned to certain dates along the X axis. (In other software) I’m used to clicking on the icon, click at a start point, moving the mouse to where you want the callout/text box, let go of the mouse and, voila, the call-out shape pops open ready for you to type. However, it seems whichever callout that I select (format/insert images), the box grows along with the line. If I shrink the box the line shrinks correspondingly away from the date on the X axis. Isn’t there a callout that allows you to start at a fixed point on the axis and have that point stay put while you extend the line to wherever in the field you would like the callout structure to reside?

My object for the Y axis title is to have 1 horizontal word close to the top of the Y axis and the other horizontal word close to the bottom. However, I’m running into 2 problem right off. First, when I double click the Y axis title box, I can move it but I cannot grab one of the blue corner balls and shrink or expand the box? Second, assuming I could expand the box to be a slender text box parallel to the Y axis, when I format axis title/alignment/text direction horizontal, the entire box is moved horizontally not just the word?


Mark
Reply With Quote
  #4  
Old 04-11-2017, 04:48 AM
jeffreybrown jeffreybrown is offline Change Y axis #'s from ascending to descending? Windows Vista Change Y axis #'s from ascending to descending? Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Sorry, been delayed.

Not sure I have an appropriate answer for your follow-up question.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. jalea148 Excel 3 01-06-2017 09:04 AM
Change Y axis #'s from ascending to descending? Shortcut to haven ascending values in row/column of cells Straitsfan Excel 1 08-09-2016 05:28 AM
Change Y axis #'s from ascending to descending? Need to Print Pages with Ascending Numbers MathewPankratz Word 1 04-07-2016 04:26 PM
Change Y axis #'s from ascending to descending? Concatenate if in descending order pgeorgilas Excel Programming 2 12-10-2014 01:35 AM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 sharath_ms PowerPoint 0 07-08-2013 10:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft