Change Plot Order for Graph in Access 2010

[undefeatedskillz26]

I have a column graph I created for a report.

The Y axis has number of days.

The X axis has Member ID.

When I make the column graph the data seems to not be in any order. The report is in order by the number of days in ascending order.

How can I have the columns with the largest number show up first and the columns get smaller. I would like the largest column all the way to the left, proceeding the next one in size so it goes from largest to smallest.

Any one have any idea, I have tried googling this for hours. Many Thanks.

 

[llkhoutx]

check this out:

https://support.office.com/en-us/ar...09a-9a4d-13f57e6e6df5?ui=en-US&rs=en-US&ad=US

You can also Google "Access" questions.

 

[undefeatedskillz26]

Hi llkhoutx,

I have been trying this for hours and could not figure out how to get to Chart Tools, Design, Layout, and format tabs and then figured out it says on the bottom of the link:

Applies To: Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007

Does anyone know anyway to change the plot order (not reverse it) to a specific way that is user defined?

 

[JHB]

Is the below what you are looking for, (else show some sample data + how you want it)?

 

[undefeatedskillz26]

Hi JHB,

So if we were to use your chart, is it possible to change the X axis to 10, 9, 8, 4, 2, and 1? If so how exactly do you do it?

My report where the chart is pulling the information is in ascending order, but the chart that is created is in a random order.

Is there any way to change the plot order to an ascending order? If you know how can you please share. Thanks again for taking the time to reply. I really appreciate it.

 

[undefeatedskillz26]

Okay everyone I figured out how to change the plot order for the graph. The answer is you must copy and paste the Data from Table/Query to the Chart Data Grid.

You go to Design View of the Chart.
Click on Property and select Row Source.
It will direct you to a Query Builder, and then you can build your Query.
After finished building your Query, go to Datasheet View of the Query you have just built, and you can copy the data and paste it to the Chart Data Grid

Thank you, thank you everyone who has helped.