Ordering graph data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
View the Row Source of the graph in query design view. Set the order as
desired and update the property.
 
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.
 
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 said:
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 said:
View the Row Source of the graph in query design view. Set the order as
desired and update the property.
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
--

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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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.

:

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
--

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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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


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.

:

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
--

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?
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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?

:

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


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.

:

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
--

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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top