PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Pivot charts question

Reply

Pivot charts question

 
Thread Tools Rate Thread
Old 15-11-2007, 11:11 AM   #1
Joe
Guest
 
Posts: n/a
Default 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
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off