What do you want to show in the chart? The duration of each activity? If
so, in a separate column calculate the duration as ={end-time-cell} -
{start-time-cell}. Now, select the cells in the leftmost column and this new
column and create the chart.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
"Shiva" wrote:
Hi all,
I am a novice player to use all the dynamic pie charts, Can some one pls
help me in plotting a PIE chart for the following Data.
I have a case similar to the following issue:
start Time end time Color
Break fast 7:00 7:30 Orange
Travel time 7:30 9:00 RED
Productive hours 9:00 15:30 GREEN
Need to plot the chart with these values; besides it has to dynamically
change if the values are changed.
Kindly provide me your suggestions in layman terms.
TIA
Shiva