S
Stephanie
Hello. My query skills are a bit lacking and I've not charted before.
I'm curious if it is possible to build a graph that has $ on the left
vertical axis, # on the right vertical axis, department on the horizontal
axis, with a bar chart for $ and a line graph for #.
If this type of charting is possible what would the set up be, meaning which
items would be marked as "row heading", "column heading" and "value"?
I've struggled with the query as well, in that having that much information
in one query makes it difficult to sum correctly so that I don't show all of
the items, just the totals to be graphed. And insight there as well would be
appreciated.
Cheers,
Stephanie
I'm curious if it is possible to build a graph that has $ on the left
vertical axis, # on the right vertical axis, department on the horizontal
axis, with a bar chart for $ and a line graph for #.
If this type of charting is possible what would the set up be, meaning which
items would be marked as "row heading", "column heading" and "value"?
I've struggled with the query as well, in that having that much information
in one query makes it difficult to sum correctly so that I don't show all of
the items, just the totals to be graphed. And insight there as well would be
appreciated.
Cheers,
Stephanie