Pivot Table Data

blair711 · Post by **blair711** » 20 Oct 2016, 13:45

Hi y'all!

I am hoping you can assist me with my pivot table. I have a bar showing downtime and another bar showing pieces lost during down time. What I need to incorporate is another set of data that shows the total daily amount of pieces lost against the second bar graph. To better understand, I have included the file.

Thank you :)

Post by **HansV** » 20 Oct 2016, 13:56

Can you explain which data (range) you want to incorporate?

blair711 · Post by **blair711** » 20 Oct 2016, 14:24

The data in column G against the data in Cell G17. I want the graph to basically state that the Orange bar(parts lost during the particular downtime) reflects the total lost amount for the day (G17)

Post by **HansV** » 20 Oct 2016, 14:41

Do you mean that you would want to display parts lost as a percentage of the total amount lost?

blair711 · Post by **blair711** » 20 Oct 2016, 19:50

g17 will change weekly as will the parts lost. So somewhere on the graph we want it to show we lost 21 parts during this specific shutdown town of the total 128(g17) lost in a day.

Post by **HansV** » 20 Oct 2016, 20:16

Where can we find that in the workbook?

blair711 · Post by **blair711** » 20 Oct 2016, 20:49

Column G holds the data for parts lost.(will change these numbers weekly.) and G17 is the total number of scraps lost for the day.

I am wondering if I can just make the orange bar say, Ex: 45/138 parts. or something like that.....

Post by **HansV** » 20 Oct 2016, 21:02

That is not possible. Pivot tables don't support custom data labels this way. Sorry!

Eileen's Lounge

Pivot Table Data

Pivot Table Data

Re: Pivot Table Data

Re: Pivot Table Data

Re: Pivot Table Data

Re: Pivot Table Data

Re: Pivot Table Data

Re: Pivot Table Data

Re: Pivot Table Data