If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charting various times. Help!!
Hi there.
I currently have a table which I have run a query on that tables like this Date. Target time. Time achieved. Diff. hh/mm/yyyy hh:mm hh:mm n I have worked out how to chart the 'Diff' column as this is in number format. However when I try and throw in the actual times into a chart I get a chart containing values from 0 through to 0.8?? I have set my format as 'short time' in both the query and the table but to no avail. I have searched everywhere and cannot find an answer. All I want is a chart with the 'target time' as a fixed line and the 'Time achieved' as a timeline running from left to right. Using the date along the bottom as a reference. Any ideas?? -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Charting various times. Help!!
Hi,
If you are only subtracting the times that would make sense. Try using the DateDiff() function. Use the following for the difference in minutes: Diff: DateDiff("n", [Target time], [Time achieved]) Clifford Bass juxey2000 wrote: Hi there. I currently have a table which I have run a query on that tables like this Date. Target time. Time achieved. Diff. hh/mm/yyyy hh:mm hh:mm n I have worked out how to chart the 'Diff' column as this is in number format. However when I try and throw in the actual times into a chart I get a chart containing values from 0 through to 0.8?? I have set my format as 'short time' in both the query and the table but to no avail. I have searched everywhere and cannot find an answer. All I want is a chart with the 'target time' as a fixed line and the 'Time achieved' as a timeline running from left to right. Using the date along the bottom as a reference. Any ideas?? -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Charting various times. Help!!
Thanks for the prompt reply but I have already done that in my query and can
produce a chart for the difference between thee two times already. I was just hoping to ba abke to plot the target verses actual times on a chart as either two lines or as bars with the time value along the left axis and the date along the bottom? I'm assuming the pivot chart is taking my 'times' from the table and converting them into some sort of numerical format?? Clifford Bass wrote: Hi, If you are only subtracting the times that would make sense. Try using the DateDiff() function. Use the following for the difference in minutes: Diff: DateDiff("n", [Target time], [Time achieved]) Clifford Bass Hi there. [quoted text clipped - 15 lines] Any ideas?? -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Charting various times. Help!!
Hi,
Sorry, I did not read your original question correctly. I am not an expert on charting. So try this: On the chart property sheet set the Y axis's (Value Axis 1) number format to be short time. Set a custom scale from 0 to 1. Hopefully that will do the trick. Clifford Bass juxey2000 wrote: Thanks for the prompt reply but I have already done that in my query and can produce a chart for the difference between thee two times already. I was just hoping to ba abke to plot the target verses actual times on a chart as either two lines or as bars with the time value along the left axis and the date along the bottom? I'm assuming the pivot chart is taking my 'times' from the table and converting them into some sort of numerical format?? -- Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
Charting various times. Help!!
Clifford you are a legend!!! I knew it was easy because no-one had asked the
question.lol. Back to access school for me!! Many MANY thanks. Alan Clifford Bass wrote: Hi, Sorry, I did not read your original question correctly. I am not an expert on charting. So try this: On the chart property sheet set the Y axis's (Value Axis 1) number format to be short time. Set a custom scale from 0 to 1. Hopefully that will do the trick. Clifford Bass Thanks for the prompt reply but I have already done that in my query and can produce a chart for the difference between thee two times already. I was just [quoted text clipped - 4 lines] I'm assuming the pivot chart is taking my 'times' from the table and converting them into some sort of numerical format?? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
#6
|
|||
|
|||
Charting various times. Help!!
Hi Alan,
Good to hear it worked. You are welcome! Clifford Bass juxey2000 wrote: Clifford you are a legend!!! I knew it was easy because no-one had asked the question.lol. Back to access school for me!! Many MANY thanks. Alan -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/201001/1 |
Thread Tools | |
Display Modes | |
|
|