![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
Once you right click on on the Y-Axis and select >> Format Axis...
Did you try >> values in reverse order... |
#3
|
|||
|
|||
![]()
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 |
#4
|
|||
|
|||
![]()
Sorry, been delayed.
Not sure I have an appropriate answer for your follow-up question. |
![]() |
|
![]() |
||||
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 |
![]() |
Straitsfan | Excel | 1 | 08-09-2016 05:28 AM |
![]() |
MathewPankratz | Word | 1 | 04-07-2016 04:26 PM |
![]() |
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 |