LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
beholder
 
Posts: n/a
Default Excel graphs with Access database

I have a problem and have just about gotten to my wits end on how to
make this work.

For a project at work, I need to be able to produce a graph of some
data in an Access Database. This database has several fields which are
similar to "Are you satisfied with our service?"-type questions and is
filled with 1 of 6 possible responses: "Excellent", "Good", "Fair",
"Poor", "No Opinion", or blank entry.

What I need is a way to count up all the Excellent responses for each
of these fields, count up the Good responses, count the Fair responses,
etc., and then generate a bar graph for each field and a visual
representation of these counts.

So far, I've had little success in generating this. The closest I got
was to import the data into Excel, and try producing a graph there,
which worked, but it wasn't pulling the right data in the right way.

I'd appreciate any help!

Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 01:19 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Error message in Excel after exporting Access query to Excel Romi Excel Discussion (Misc queries) 0 June 6th 05 02:53 PM
Managing an Access Database from Excel Kostis Vezeridis Excel Discussion (Misc queries) 2 February 11th 05 05:21 PM
Excel aficionado wants to learn Access Hari Excel Discussion (Misc queries) 0 December 3rd 04 05:45 AM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"