Need help creating a chart, if possible.

crystal.schroeder

We get data monthly/quarterly from carriers and I am trying to create a dashboard for an easier visual on what we have and dont have but i cant seem to find a good solution. I created two different sheets but i cant use the data from either. So for example, I want something that shows August and updates once i check the box that we have August, or when I change it from no to yes. Thoughts/suggestions?

Adam Murphy

I am unsure why you cannot use either of these is a report/dashboard. Maybe if you can describe what you'd like your dashboard/report to look like that would help.

crystal.schroeder

It tells me that selected data can not be charted - i believe because it has no values to it. I am looking for something that shows if the carrier file for that month has been received or not. I check the box once its received in the sheet.

Vivien Chong

I am just thinking out loud. Instead of marking Yes or No in your sheet 2, what about stating 1 for Yes, and 0 for No? That will help to calculate the total numbers?