Full Version: Simple Pie Charts
UtterAccess Forums > Microsoft® Access > Access Forms
nmurray
Hi,
I've created a db that scans folders for their size. These folders are controlled by quota management software, which caps the useage based on an upper limit. What I'd like to do is create a pie chart for each folder on a form showing how close to the quota limit they are, just like the pie chart you see for the C: drive on your PC. I've been messing with it for a while now and am getting nowhere. I've tried doing seperate queries for each folder, which seems the sensible thing to do, but the chart wizard seems to want the data for a field rather than a row. (I'm useless with charts) Here's the data from the query.
Folder.......................................Limit..........used
\\FileServer1\Admin\..................1000.........786.82
\\FileServer1\dcm\.....................200...........0
\\FileServer1\Training\...............200...........146.45
\\FileServer1\High Risk\.............300...........286.36
etc...........
AvgJoe
nmurray,
ere's a little something that might get you going in the right direction.
AvgJoe
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.