|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 28th, 2005, 07:07 PM
posted to microsoft.public.access.reports
|
|||
|
|||
How do I change the order of the bars in a column chart?
I have a column chart with quantities on the Y axis and categories on the X
axis. The underlying query is set to return the quantities in descending order. How do set up the chart to display the bars in desceding order with the tallest bar to the left? 
|
|
#2
November 28th, 2005, 09:08 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
How do I change the order of the bars in a column chart?
Change the SQL of your Row Source property to sort by the bar value desc.
-- Duane Hookom MS Access MVP -- "Stu" wrote in message ... I have a column chart with quantities on the Y axis and categories on the X axis. The underlying query is set to return the quantities in descending order. How do set up the chart to display the bars in desceding order with the tallest bar to the left?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change chart colors at report run time | rogge | Setting Up & Running Reports | 1 | March 31st, 2005 01:37 PM |
| How do you change the order of the slices in a pie chart? | weekendbeacher | New Users | 1 | March 29th, 2005 02:01 AM |
| To create a stacked column chart and group the stacked bars togeth | Jacqueline | Charts and Charting | 1 | February 17th, 2005 11:05 PM |
| Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
| inserting a total on a column chart | Jon Peltier | Charts and Charting | 1 | April 19th, 2004 05:01 PM |
Linear Mode
