![]() |
Pivot charts question
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 |
All times are GMT +1. The time now is 04:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com