PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Pivot charts question
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Pivot charts question
![]() |
Pivot charts question |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

