Hi,
I have this chart, where the logic of line chart is "lower is better",but as per general rule the greater line goes up,so how to do the reverse.
Hi,
I have this chart, where the logic of line chart is "lower is better",but as per general rule the greater line goes up,so how to do the reverse.
Select the Secondarly Vertical (Value) Series, either by selecting in the "Current Selection" dropdown and clicking the "Format Selection" button, or right-clicking on the axis in the chart and selecting "Format Axis" from the dropdown menu.
In the "Format Axis" dialogue box
Axis Options tab
Click the "Values in reverse order" box to enable
Now it will flip the orientation of the secondary axis so zero is at the top and bigger numbers go down.
are you looking to change the RANK order so that the lowest value is ranked lower - not sure what you mean otherwise
you have attached a chart , can you also show what you would like the chart to look like to get the results you expect
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I just noticed that the thread title is probably an Rule 1 violation as well, that should probably be changed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks