K
KIM
I have used Chart wizard to construct a graph in a report. There is a lot of
information on the graph so I need it to fit a landscape page. When I veiw
the report the graph is small - I have try to re-size it in design view but
it is awkard and can end up on several sheets. Is there an easier way of
changing the size onf the graph?
Also is it possible to edit the names of the legends without having to
change the source data?
The data for the graph is from a query which I have tried to sort into
asscending order with refence to the borehole number eg BH3 to BH11. However
as with excel the ordered data starts with BH 10 and BH11 the BH3 - BH9. Is
there a way to sort the data so it shows BH3 - BH11 and thus this would be in
the right order on the graph?
Thank you!
information on the graph so I need it to fit a landscape page. When I veiw
the report the graph is small - I have try to re-size it in design view but
it is awkard and can end up on several sheets. Is there an easier way of
changing the size onf the graph?
Also is it possible to edit the names of the legends without having to
change the source data?
The data for the graph is from a query which I have tried to sort into
asscending order with refence to the borehole number eg BH3 to BH11. However
as with excel the ordered data starts with BH 10 and BH11 the BH3 - BH9. Is
there a way to sort the data so it shows BH3 - BH11 and thus this would be in
the right order on the graph?
Thank you!