Custom Graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to create a graph that shows the days & hours a person uses
a room. I need a color bar to represent the hours of each day used by each
person. So there could be multiple bars on the same day (days shown
horizontally, hours veritically) Is there a way to graph this using access,
or another MS Office product called from ACCESS? I am currently using Office
2003
 
How about a calendar display where on each day of the calendar you would
see:
Joe 8
Sally 6
Tom 5.5
You could enter the name and hours right on the calendar form and print out
a report of the calendar showing names and hours.

I developed a scheduling calendar module that I could use to implement the
above in your database. If you are interested, contact me at my email
address below and I will email you a screen shot of the scheduling calendar
module.
 
I really need it to visually show a column where each hour the room is used
it is colored by the user of the room. Columns numbered by the day, and rows
indicating the hour. I can do it by hand using excel, but it has to be done
manually. I need a way to automate it. I can set up the database relational
files to handle the information, my problem is converting it into a graph.

Thanks
 
Have you tried viewing your table as pivotchart, it brings up a blank chart
and a list of your fields which you can just drag and drop into each of the
axis. If you are familiar with access and excel it should be fairly straight
foward.

HTH

rico
 
Honestly,

I am fairly ignorant of excel. My experience with ACCESS is 5 years
outdated, I am trying to refresh that knowledge now. I am unfamiliar with
pivotcharts and what they can do. I can e-mail an example .xls spreadsheet to
clarify what I'm trying to produce.

Thanks for the info, I will try and research pivotcharts.
 
Back
Top