Need your expertise in creating this pie chart

  • Thread starter Thread starter Shiva
  • Start date Start date
S

Shiva

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
 
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
 
Back
Top