Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by maroulator
at 2024-08-12 19:59:19
Point:500 Replies:4 POST_ID:828740USER_ID:10
Topic:
Microsoft Excel Spreadsheet Software;;
To whom it may concern,
This questions on the graph in the attached spreadsheet.
Is there a way to re-arrange the counterparty names on the Y-axis in alphabetical or reverse alphabetical order by only playing directly with the graph and WITHOUT touching the source table?
Thanks in advance,
-Maroulator
This questions on the graph in the attached spreadsheet.
Is there a way to re-arrange the counterparty names on the Y-axis in alphabetical or reverse alphabetical order by only playing directly with the graph and WITHOUT touching the source table?
Thanks in advance,
-Maroulator
Attachment:Example.xlsx
Expert: Saqib Husain, Syed replied at 2024-08-15 20:47:41
For future questions please keep this in mind that "Cannot be done" is a very valid response and just because it does not help you as desired does not mean that it should be graded low. Usually a B grade is given when the answer is not complete and needs more work/research to complete it.
Expert: duncanb7 replied at 2024-08-12 23:38:04
now I understood the question, ssaqibh is correct and only way to do that on Excel cell.
You can also lock the graph on VBA if need
Duncan
You can also lock the graph on VBA if need
Duncan
Accepted Solution
Expert: Saqib Husain, Syed replied at 2024-08-12 23:31:26
500 points GOOD
The graph will follow the same order of the data. You can not sort it separately. You might like to consider a dummy range which picks data from the source table and from which the graph is plotted.
Expert: duncanb7 replied at 2024-08-12 23:03:06
there is a button for alphabetical order or reverse order in excel sheet, did you use it ?
http://office.tizag.com/excelTutorial/excelsorting.php
Or do you want to do it on VBA? please specifiy in thread tag or topic .
Or write it clearly what you want
http://office.tizag.com/excelTutorial/excelsorting.php
Or do you want to do it on VBA? please specifiy in thread tag or topic .
Or write it clearly what you want
