Dashboard Help Needed Please

[StudioCity]

Hello everyone,

I need some help please.
I am attaching a spreadsheet that I have made with 28 controls.

I have a dashboard sheet too, but this is where I'm having some issues.
I can only see 10 0f the 28 controls on the dashboard, and C01, C08 are missing.

Also the breakdown status of all categories is also missing. There was meant to be a pie chart there.

Is there anyway I can get the following information for each control on the dashboard please:

1. Evidence received
2. Current status (I have managed to do this I think, but its not showing up on the dashboard)

Any help gratefully received.

Loading Google Sheets

Many thanks

 

[StudioCity]

Anyone please?

 

[Jar888]

Not sure if I can help much, but looking at your data range for one of the charts on Sheet2, it looks like you have some reference errors in both columns 1 and 8. This will make those show up as 0.

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Dashboard help needed please

Hello everyone, I need some help please. I am attaching a spreadsheet that I have made with 28 controls. I have a dashboard sheet too, but this is where I'm having some issues. I can only see 10 0f the 28 controls on the dashboard, and C01, C08 are missing. Also the breakdown status...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[StudioCity]

Sorry Rory I will edit my post to provide the link
Was getting desperate for help!

 

[StudioCity]

Could anyone help please?