Chart orientation

Just a quick one...

I can't see how I can change how a chart displays data in
a line graph - change the X and Y axis around.

For example, I want the 1 to 100 to display along the
bottom and not at the left as it does... is this possible?

Also I'd like to create a stacked bar graph under this
(have the line graph transparent) that shows the standard
deviation around the mean. In Excel I can do this by
selecting two series ranges say "low" and "difference" but
can't quite see how this can be done in Access.

I don't really understand the graph wizard in Access so
any help is greatly appreciated.

Regards,

Averil Pretty