J
Joe
I have created a pivot chart that shows the elapsed time of a number
of jobs. I have the following layout for the pivot table:
Date - Column
JobName - Row
Sum of Elapsed Time - Data
You can probably guess that the x axis shows the job name, and the y
axis shows the time range from zero to about 2 hours.
Now this is fine but Im really looking to add the start time to the
graph. It would be briliant if i could have the chart with floating
bars with the y axis showing the actual time in the day that the job
started and have a solid bar depicting the amount of minutes and
seconds that the job took to run. I have both the start time and end
time available from the database that I am linking to.
However if the floating bars option is not possible, can I add the
start time as a line on a seperate axis, 1st axis would show the time
that the job took (zero to about 2 hours) and the secondary axis would
show the time (midnight to midnight)
Thanks for any help
of jobs. I have the following layout for the pivot table:
Date - Column
JobName - Row
Sum of Elapsed Time - Data
You can probably guess that the x axis shows the job name, and the y
axis shows the time range from zero to about 2 hours.
Now this is fine but Im really looking to add the start time to the
graph. It would be briliant if i could have the chart with floating
bars with the y axis showing the actual time in the day that the job
started and have a solid bar depicting the amount of minutes and
seconds that the job took to run. I have both the start time and end
time available from the database that I am linking to.
However if the floating bars option is not possible, can I add the
start time as a line on a seperate axis, 1st axis would show the time
that the job took (zero to about 2 hours) and the secondary axis would
show the time (midnight to midnight)
Thanks for any help