Forum home » Delegate support and help forum » Microsoft Excel Training and help » Order data in graphs

Order data in graphs

ResolvedVersion 2016

Mon 21 May 2018, 15:06 Delegate 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:13 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips

Order data in graphs

Order data in graphs

RE: Order data in graphs

Excel articles

Excel tip:

Using the Quick Access Toolbar in Excel2010