98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Order data in graphs
Order data in graphs
Resolved · Low Priority · Version 2016
Mon 21 May 2018, 15:06Delegate Sophie said...
Sophie has attended:
Excel Advanced course
Order data in graphs
Is there a way of ordering the data in a graph directly from a graph so that it shows the most frequently occurring category - least frequently occurring category? So with a column chart you would have the longest column at one end and the shortest at the other.
Or does this have to be done by filtering the data directly itself?
Mon 21 May 2018, 16:13Trainer Wendy said...
RE: Order data in graphs
Hi Sophie
Unfortunately, you need to sort the data from the area that the graph is drawing from, however, if your data grows you will need to re-sort it to take into account the new information
Hope this helps
Kind regards
Wendy Canelas
Microsoft Office Trainer
Mon 28 May 2018: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Apply Autosum with keyboard shortcutIf you press Alt and = at the same time, it applies autosum. |
