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
|
|||
|
|||
Ordering graph data
I have a MS Access report in which I have placed a bar graph to display the
hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#2
|
|||
|
|||
View the Row Source of the graph in query design view. Set the order as
desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#3
|
|||
|
|||
Thank you for your comments. But I am not sure that will work the row source
for the graph is as follows: TRANSFORM Sum([TIME DOWN]) AS [SumOfTIME DOWN] SELECT [Machine no] FROM [Monthly downtime] GROUP BY [Machine no] PIVOT [Reason]; Any further help is greatly appreciated. "Duane Hookom" wrote: View the Row Source of the graph in query design view. Set the order as desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#4
|
|||
|
|||
I'm not sure this is possible since the row source is a crosstab. What would
you expect to see if machines all had different Max values from different reasons? -- Duane Hookom MS Access MVP "tredd" wrote in message ... Thank you for your comments. But I am not sure that will work the row source for the graph is as follows: TRANSFORM Sum([TIME DOWN]) AS [SumOfTIME DOWN] SELECT [Machine no] FROM [Monthly downtime] GROUP BY [Machine no] PIVOT [Reason]; Any further help is greatly appreciated. "Duane Hookom" wrote: View the Row Source of the graph in query design view. Set the order as desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#5
|
|||
|
|||
What I am looking to do is have each machine's graph have the reasons in
order of magnitude. Machine 1 could be completley different order than machine 2 and so on. Probably not possible with access? "Duane Hookom" wrote: I'm not sure this is possible since the row source is a crosstab. What would you expect to see if machines all had different Max values from different reasons? -- Duane Hookom MS Access MVP "tredd" wrote in message ... Thank you for your comments. But I am not sure that will work the row source for the graph is as follows: TRANSFORM Sum([TIME DOWN]) AS [SumOfTIME DOWN] SELECT [Machine no] FROM [Monthly downtime] GROUP BY [Machine no] PIVOT [Reason]; Any further help is greatly appreciated. "Duane Hookom" wrote: View the Row Source of the graph in query design view. Set the order as desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#6
|
|||
|
|||
I can't picture how a single crosstab can have different sorts of the
generated column. Perhaps if you enter the results view of a couple machines and reasons, you could illustrate what you want. -- Duane Hookom MS Access MVP "tredd" wrote in message ... What I am looking to do is have each machine's graph have the reasons in order of magnitude. Machine 1 could be completley different order than machine 2 and so on. Probably not possible with access? "Duane Hookom" wrote: I'm not sure this is possible since the row source is a crosstab. What would you expect to see if machines all had different Max values from different reasons? -- Duane Hookom MS Access MVP "tredd" wrote in message ... Thank you for your comments. But I am not sure that will work the row source for the graph is as follows: TRANSFORM Sum([TIME DOWN]) AS [SumOfTIME DOWN] SELECT [Machine no] FROM [Monthly downtime] GROUP BY [Machine no] PIVOT [Reason]; Any further help is greatly appreciated. "Duane Hookom" wrote: View the Row Source of the graph in query design view. Set the order as desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#7
|
|||
|
|||
I will try to explain
Say my graph for machine 1 contains five bars for reasons "a" "b" "c" "d" and "e". Bar 1 ("a" reason) is 3 hours high on the Y scale. Bar 2 ("b" reason) is 5 hours high on the Y scale. Bar 3 ("c" reason) is 2 hours high on the Y scale. Bar 4 ("d" reason) is 1 hour high on the Y scale. Bar 5 ("e" reason) is 7 hours high on the Y scale. I would like the bars to be in descending order so that reason "e" would be the first bar followed by "b" then "a" "c" and "d". If this can not be done that's ok. I thank you for your time and consideration. "Duane Hookom" wrote: I can't picture how a single crosstab can have different sorts of the generated column. Perhaps if you enter the results view of a couple machines and reasons, you could illustrate what you want. -- Duane Hookom MS Access MVP "tredd" wrote in message ... What I am looking to do is have each machine's graph have the reasons in order of magnitude. Machine 1 could be completley different order than machine 2 and so on. Probably not possible with access? "Duane Hookom" wrote: I'm not sure this is possible since the row source is a crosstab. What would you expect to see if machines all had different Max values from different reasons? -- Duane Hookom MS Access MVP "tredd" wrote in message ... Thank you for your comments. But I am not sure that will work the row source for the graph is as follows: TRANSFORM Sum([TIME DOWN]) AS [SumOfTIME DOWN] SELECT [Machine no] FROM [Monthly downtime] GROUP BY [Machine no] PIVOT [Reason]; Any further help is greatly appreciated. "Duane Hookom" wrote: View the Row Source of the graph in query design view. Set the order as desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
#8
|
|||
|
|||
I expected to see multiple machines which might have all had different bar
heights for different reasons. Apparently you are only viewing the information for only one machine per graph instance. Are you using Link Master/Child to achieve this? If you are linking master child, you might be able to change the row source query to a simple totals query SELECT [Machine no], [Reason], Sum([TIME DOWN]) AS [SumOfTIME DOWN] FROM [Monthly downtime] GROUP BY [Machine no], [Reason] ORDER BY [Machine no], Sum([Time Down]) DESC; This might take some fiddling with the graph properties. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I will try to explain Say my graph for machine 1 contains five bars for reasons "a" "b" "c" "d" and "e". Bar 1 ("a" reason) is 3 hours high on the Y scale. Bar 2 ("b" reason) is 5 hours high on the Y scale. Bar 3 ("c" reason) is 2 hours high on the Y scale. Bar 4 ("d" reason) is 1 hour high on the Y scale. Bar 5 ("e" reason) is 7 hours high on the Y scale. I would like the bars to be in descending order so that reason "e" would be the first bar followed by "b" then "a" "c" and "d". If this can not be done that's ok. I thank you for your time and consideration. "Duane Hookom" wrote: I can't picture how a single crosstab can have different sorts of the generated column. Perhaps if you enter the results view of a couple machines and reasons, you could illustrate what you want. -- Duane Hookom MS Access MVP "tredd" wrote in message ... What I am looking to do is have each machine's graph have the reasons in order of magnitude. Machine 1 could be completley different order than machine 2 and so on. Probably not possible with access? "Duane Hookom" wrote: I'm not sure this is possible since the row source is a crosstab. What would you expect to see if machines all had different Max values from different reasons? -- Duane Hookom MS Access MVP "tredd" wrote in message ... Thank you for your comments. But I am not sure that will work the row source for the graph is as follows: TRANSFORM Sum([TIME DOWN]) AS [SumOfTIME DOWN] SELECT [Machine no] FROM [Monthly downtime] GROUP BY [Machine no] PIVOT [Reason]; Any further help is greatly appreciated. "Duane Hookom" wrote: View the Row Source of the graph in query design view. Set the order as desired and update the property. -- Duane Hookom MS Access MVP -- "tredd" wrote in message ... I have a MS Access report in which I have placed a bar graph to display the hours a machine is down and the reason it was down. The graph orders the bars (reasons) alphabetically. I would prefer to have the bars ordered by their value biggest to smallest. Is ther a way to acomplish this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
Power Point Graphs- caps stick in data editor & highlights mult. c | Ryan | Powerpoint | 1 | December 15th, 2004 01:07 AM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Chart data with 2 different set of data on the same graph | Wellie | General Discussion | 1 | September 20th, 2004 03:30 PM |