How to Create an Excel Chart based on exceptions

[lemondifficult]

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 Number	Opportunity	Current Contract End Date	Annual Consumption (kWH)	Current Supplier	Company/Division Name	Contracting Entity
Latcham Direct	21474703	Latcham Direct - Gas	30/09/2015	253,826	Total Gas & Power	-	Latcham Direct
Latcham Direct	9177951808	Latcham Direct - Gas	30/09/2015	1	Total Gas & Power	-	Latcham Direct
Milford Haven Port Authority	2100041045720	-	28/02/2015	-	Scottish & Southern Energy	Quay Side Estates	Quay Side Estates
Howard Hunt Group	1900011426140	Howard Hunt - HH 2014	30/09/2014	-	EDF	Howard Hunt (City) Ltd	Howard Hunt (City) Ltd
Howard Hunt Group	1900060958158	Howard Hunt - HH 2014	30/09/2014	-	EDF	Howard Hunt (City) Ltd	Howard Hunt (City) Ltd
Howard Hunt Group	1900060632035	Howard Hunt - HH 2014	30/09/2014	-	EDF	Howard Hunt (City) Ltd	Howard Hunt (City) Ltd
Aish Technologies	2000051635811	-	28/02/2016	858,551	Scottish & Southern Energy	Aish Technologies	Aish Technologies Ltd
Aish Technologies	9327839304	-	28/02/2015	143,376	Scottish & Southern Energy	Aish Technologies Ltd	Aish Technologies Ltd
Aish Technologies	8937376005	-	28/02/2016	651,845	GDF Suez	Aish Technologies	Aish Technologies Ltd
Knorr-Bremse	45781307	Knorr-Bremse - Gas 2016 (CV)	31/05/2016	1,701,291	Gazprom	-	Knorr Bremse Systems for Commercial Vehicles
Knorr-Bremse	15721102	Knorr-Bremse - Gas 2016 (CV)	31/05/2016	808,659	Gazprom	-	Knorr Bremse Systems for Commercial Vehicles
Knorr-Bremse	9116471707	Knorr-Bremse - Gas 2016 (CV)	31/05/2016	164,275	Gazprom	-	Knorr Bremse Systems for Commercial Vehicles
Reddiplex Ltd	2199989673229	Ventura Bay Elec 2014	30/11/2014	-	Scottish & Southern Energy	Ventura Bay Limited	Ventura 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

 

[steve the fish]

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.

 

[lemondifficult]

thanks steve. yeah, i have just done that actually

still working on the stacked chart though