The columns are values for the years 2022, 2023, and 2024. All the cells for the past years are filled (they have values in all 365 rows), but the column for 2024 only has values for the days that have passed up to today. The line chart correctly shows the values for the years 2022 and 2023, but the line for 2024 ends on the day of the last entered value and from there it shows a value of 0. Even though there are no values, it shows 0 until completing the 365 rows. Could I get a chart like the one attached that for the line of 2024 only shows the values of the cells that have values and DOES NOT SHOW the value 0 for the cells that have no values (blue line in attached graph)?
I have a table with several columns.
The columns contain numerical content.
The rows are the days of the year (365 rows).
The columns are values for the years 2022, 2023, and 2024. All the cells for the past years are filled (they have values in all 365 rows), but the column for 2024 only has values for the days that have passed up to today. The line chart correctly shows the values for the years 2022 and 2023, but the line for 2024 ends on the day of the last entered value and from there it shows a value of 0. Even though there are no values, it shows 0 until completing the 365 rows. Could I get a chart like the one attached that for the line of 2024 only shows the values of the cells that have values and DOES NOT SHOW the value 0 for the cells that have no values (blue line in attached graph)?
Saludos
Juan
Attached files: Captura de pantalla 2024-11-05 175418.png
this is the solution perfect for my question.
Very tanks
Juan