How to Create an Excel Chart based on exceptions

lemondifficult

New Member
Joined
Mar 19, 2014
Messages
40
Hi,

i was just wondering if anyone could help with a chart im trying to create. I have an exception report taken from Salesforce of accounts that are missing data for any one of a selection of cells. Im looking to display this information in a chart that will only report on the information that is missing. I have provided an output of the report below;

Account Name
M NumberOpportunityCurrent Contract End DateAnnual Consumption (kWH)Current SupplierCompany/Division NameContracting Entity
Latcham Direct21474703Latcham Direct - Gas30/09/2015253,826Total Gas & Power-Latcham Direct
Latcham Direct9177951808Latcham Direct - Gas30/09/20151Total Gas & Power-Latcham Direct
Milford Haven Port Authority2100041045720-28/02/2015-Scottish & Southern EnergyQuay Side EstatesQuay Side Estates
Howard Hunt Group1900011426140Howard Hunt - HH 201430/09/2014-EDFHoward Hunt (City) LtdHoward Hunt (City) Ltd
Howard Hunt Group1900060958158Howard Hunt - HH 201430/09/2014-EDFHoward Hunt (City) LtdHoward Hunt (City) Ltd
Howard Hunt Group1900060632035Howard Hunt - HH 201430/09/2014-EDFHoward Hunt (City) LtdHoward Hunt (City) Ltd
Aish Technologies2000051635811-28/02/2016858,551Scottish & Southern EnergyAish TechnologiesAish Technologies Ltd
Aish Technologies9327839304-28/02/2015143,376Scottish & Southern EnergyAish Technologies LtdAish Technologies Ltd
Aish Technologies8937376005-28/02/2016651,845GDF SuezAish TechnologiesAish Technologies Ltd
Knorr-Bremse45781307Knorr-Bremse - Gas 2016 (CV)31/05/20161,701,291Gazprom-Knorr Bremse Systems for Commercial Vehicles
Knorr-Bremse15721102Knorr-Bremse - Gas 2016 (CV)31/05/2016808,659Gazprom-Knorr Bremse Systems for Commercial Vehicles
Knorr-Bremse9116471707Knorr-Bremse - Gas 2016 (CV)31/05/2016164,275Gazprom-Knorr Bremse Systems for Commercial Vehicles
Reddiplex Ltd2199989673229Ventura Bay Elec 201430/11/2014-Scottish & Southern EnergyVentura Bay LimitedVentura Bay Limited

<tbody>
</tbody>

Basically i want either a bar chart with Opportunity, Current Contract End Date, Annual Consumption (kWH), Current Supplier, Company/Division Name, and Contracting Entity on the x-axis, and then a count of how many fields with blank ("-") data on the y-axis for each category

or

a stacked bar chart with Account Names along the x-axis, and a count of the amount of bank data for each category on the y-axis.

Has anyone any ideas on how i can do this. Its probably straightforward but i just cant work it out! Any help is appreciated.

Thanks in advance.

Micheal
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,388
Office Version
  1. 365
Platform
  1. Windows
Easiest is to create another table with unique account names then use countif on the present table to count the number of dashes. Then chart new table.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,814
Messages
5,638,493
Members
417,029
Latest member
lingx86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top