|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Custom GraphI 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. -- Show quotePC Datasheet Your Resource For Help With Access, Excel And Word Applications resou***@pcdatasheet.com www.pcdatasheet.com "Blondie96" <Blondi***@discussions.microsoft.com> wrote in message news:900051F6-0BF3-4E3C-97F6-5403AD2C88C2@microsoft.com... > 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 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 Show quote "PC Datasheet" wrote: > 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. > > -- > PC Datasheet > Your Resource For Help With Access, Excel And Word Applications > resou***@pcdatasheet.com > www.pcdatasheet.com > > > > "Blondie96" <Blondi***@discussions.microsoft.com> wrote in message > news:900051F6-0BF3-4E3C-97F6-5403AD2C88C2@microsoft.com... > > 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 > > > 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 Show quote "Blondie96" wrote: > 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 > > "PC Datasheet" wrote: > > > 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. > > > > -- > > PC Datasheet > > Your Resource For Help With Access, Excel And Word Applications > > resou***@pcdatasheet.com > > www.pcdatasheet.com > > > > > > > > "Blondie96" <Blondi***@discussions.microsoft.com> wrote in message > > news:900051F6-0BF3-4E3C-97F6-5403AD2C88C2@microsoft.com... > > > 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 > > > > > > 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. Show quote "rico" wrote: > 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 > > "Blondie96" wrote: > > > 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 > > > > "PC Datasheet" wrote: > > > > > 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. > > > > > > -- > > > PC Datasheet > > > Your Resource For Help With Access, Excel And Word Applications > > > resou***@pcdatasheet.com > > > www.pcdatasheet.com > > > > > > > > > > > > "Blondie96" <Blondi***@discussions.microsoft.com> wrote in message > > > news:900051F6-0BF3-4E3C-97F6-5403AD2C88C2@microsoft.com... > > > > 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 > > > > > > > > > You could modify one of the calendar reports found at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. -- Show quoteDuane Hookom MS Access MVP "Blondie96" <Blondi***@discussions.microsoft.com> wrote in message news:900051F6-0BF3-4E3C-97F6-5403AD2C88C2@microsoft.com... >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  |
|||||||||||||||||||||||
Other interesting topics