Pie chart for elapsed time

**cell-dweller** · 06-04-2010, 01:21 AM

I have an elapsed time percentage of days (actual days vs days in month) and am trying to use a pie chart but see nothing. is it because it is in % manner? how can i get it to show?

**pike** · 06-04-2010, 03:36 AM

Hi cell-dweller

chart cell1= (days/days in Month)*100
cell2= 100-cell1

**Andy Pope** · 06-04-2010, 03:50 AM

With a pie you do not need to calculate the percentages as it will automatically do it.

Cell1: =Days
Cell2: =DaysInMonth-Cell1

The attached shows the same results, although different data labels.

If you are actually seeing nothing then you need to post an example of your data and chart.

**cell-dweller** · 06-20-2010, 06:59 PM

Thanks. This has been solved.

**cell-dweller** · 06-28-2010, 06:21 PM

Thought I had this one figured out. I can not get the percentage to reflect accurately and i know it is problably something silly i am doing.
Please help if you can. I would like the pie chart to relfect elapsed time in % terms.