This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How do I change the bottom blue line (3) to show it higher than a (8)? Also how do I show the blue line as "Position" the way the red line is displayed.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Click anywhere in the chart.
Activate the Format tab of the ribbon (to the right of Chart Design).
Select Vertical (Value) Axis from the Chart Elements dropdown in the Current Selection group.
Click Format Selection.
Under Axis Options, tick the check box 'Values in reverse order'.
It should work if you display the primary vertical axis and secondary vertical axis:
See the demo workbook at https://www.dropbox.com/s/zhyngsw2k23hs71/Chart1.xlsx?dl=1
Please post more information - a screenshot, or a link to a sample workbook.
Thanks HansV
HansV Sorry about that, it was there the last time I looked but has somewhat dissapeared?? As you can see being in third position is much better than being in fifteenth position but my graph shows this is not the case