How to chart data

davital

Hello, I am trying to chart this data as a bar chart:

but when I try to visualize it, I get this weird error without any explanation about it:

What should I do?

Paul Newcome

You have to have numbers to chart. What exactly are you trying to chart and how?

davital

I want to chart a time series with that shows for each date who many audit results there are for each date

Thee dates will be the the x axis and the results will be the y axis and it will show number of times the results were chosen.

like in 08/11/23 a bar with "Incomplete - in process" 2 times

Paul Newcome

You would need a separate sheet that has each date listed down a date type column. You would then have a separate column for each of the different statuses and use COUNTIFS with cross sheet references to get the numbers generated. Once you set this sheet up, you will be able to use this metrics sheet to generate your chart.