I've made an xy scatter chart in an Access report that would be absolutely perfect if the axes were switched. Is there an easy way to do this?
The chart consists of the following fields:
DepthTo Fines Gravel LabFines LabGravel
(feet) (%) (%) (%) (%)
Depth needs to be the y-axis. Right now on my chart depth is the x-axis. If only I could rotate the chart 90 degrees!
I have easily done these graphs in Excel but can't seem to do them in Access.