Ok I've seen a few post about this, but none of them seem to be working for me. Here is a sample of my pivot table.


Data
Equipment Description Count of WO No Count of Task No
Falcon Wash 559 544
Makino1 206 196
ECM 205 157
Kremlin(Gray) 202 200
Kremlin(Green) 202 201
Kremlin(Yellow) 202 201

Where 'Count of WO No' is the total number of work orders per machine and 'Count of Task No' is the number of WO (work orders) that are Tasks (Preventative maintenance measures).

What I need to chart is the percentage of WOs that are NOT Tasks.
I know the formula to find this info but I need to know how to get in a table that will update with the rest of the workbook.

formula = (WO-Task)/WO*100
i.e. (559-544)/559*100= 2.7% which means that 2.7% of the total (Falcon Wash) WOs are not Tasks.

The WO and Task info is pulled from a MS database (if that makes a difference)

I have roughly 300 machines that I need to track on a monthly basis, so entering this info manually is not an option.

Your help is much appreciated.

Terry

But what is your question? Make the table of data and chart it.
Sorry if I am being dense
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"DeFautT" wrote in message
...

Ok I've seen a few post about this, but none of them seem to be working
for me. Here is a sample of my pivot table.


Data
Equipment Description Count of WO No Count of Task No
Falcon Wash 559 544
Makino1 206 196
ECM 205 157
Kremlin(Gray) 202 200
Kremlin(Green) 202 201
Kremlin(Yellow) 202 201

Where 'Count of WO No' is the total number of work orders per machine
and 'Count of Task No' is the number of WO (work orders) that are Tasks
(Preventative maintenance measures).

What I need to chart is the percentage of WOs that are NOT Tasks.
I know the formula to find this info but I need to know how to get in a
table that will update with the rest of the workbook.

formula = (WO-Task)/WO*100
i.e. (559-544)/559*100= 2.7% which means that 2.7% of the total (Falcon
Wash) WOs are not Tasks.

The WO and Task info is pulled from a MS database (if that makes a
difference)

I have roughly 300 machines that I need to track on a monthly basis, so
entering this info manually is not an option.

Your help is much appreciated.

Terry




--
DeFautT

Hi,

You can make the calculation in the pivot table and then plot that as a
pivot chart:

1. Put your cursor in any data field of the pivot table and choose
PivotTable, Formulas, Calculated Field.
2. Enter a name for the new field
3. In the formula box enter = (WO-Task)/WO (forget the 100 - you want
percents)
4. Click OK.
5. Select the new field in the pivot table and format it to %

6. Click the PivotChart tool
7. Open the drop-down for Data and uncheck all but your new field.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"DeFautT" wrote:


Ok I've seen a few post about this, but none of them seem to be working
for me. Here is a sample of my pivot table.


Data
Equipment Description Count of WO No Count of Task No
Falcon Wash 559 544
Makino1 206 196
ECM 205 157
Kremlin(Gray) 202 200
Kremlin(Green) 202 201
Kremlin(Yellow) 202 201

Where 'Count of WO No' is the total number of work orders per machine
and 'Count of Task No' is the number of WO (work orders) that are Tasks
(Preventative maintenance measures).

What I need to chart is the percentage of WOs that are NOT Tasks.
I know the formula to find this info but I need to know how to get in a
table that will update with the rest of the workbook.

formula = (WO-Task)/WO*100
i.e. (559-544)/559*100= 2.7% which means that 2.7% of the total (Falcon
Wash) WOs are not Tasks.

The WO and Task info is pulled from a MS database (if that makes a
difference)

I have roughly 300 machines that I need to track on a monthly basis, so
entering this info manually is not an option.

Your help is much appreciated.

Terry




--
DeFautT

Thanks for the response. I followed your instructions, but for some reason, the calculation is returning 100% for every machine. There must be something I am missing. I created the calculated field, left off the (*100) from my formula, formated the new field as a percent, but it is not working. Any other suggestions?