ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pivot charts question (https://www.excelbanter.com/charts-charting-excel/166175-pivot-charts-question.html)

Joe[_8_]

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