Column Chart with Oldest date per facility is Shown.

sub80

New Member
Joined
Oct 17, 2020
Messages
8
Office Version
  1. 2016
Platform
  1. Windows
Hi Guys;

I have a pivot table as below where when the equipment is serviced the last service date is not shown. which is used to show multiple charts. The table has 1000 entries and expected to double. One chart which am trying to show is a column chart where the oldest four equipment with the tags and last service dates for each Facility is shown.

S.I.FACILITYEQUIPMENTTAGLAST SERVICE DATESTATUS
8F1FANF1-F-08A10-Jan-2016PENDING
11F4PUMPF4-P-011A02-May-2017PENDING
7F3PUMPF3-P-08B06-Jun-2019PENDING
6F4GENERATORF4-G-06A12-Feb-2020PENDING
3F3PUMPF3-P-03C24-Mar-2020PENDING
4F1MOTORF1-M-04A12-Apr-2020PENDING
12F3PUMPF3-P-010A03-Aug-2020PENDING
1F1COMPRESSORF1-C-01A13-Oct-2020PENDING
2F2PUMPF2-P-02ADONE
5F1FANF1-F-05ADONE
9F3COMPRESSORF3-C-09ADONE
10F4MOTORF4-M-010ADONE

1604345133469.png


How can I display the service date and reduce to 4 equipment per facility.

Regards;
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,118,850
Messages
5,574,652
Members
412,607
Latest member
caner
Top