Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have some category data for year 2022 ,and no data for 2023 and 2024.
Now in combo chart If select year 2022, it has some data so its displayed but for 2023 and 2024 there is no data for this catageory,in that case the graph is hows zero value .but It should be hidden ,
any ideas to show that value by condition using like if year matches then it should show data else it should be suppressed.
can you share screen shot of your chart.
just guess try chart property > Appearance > X - axis > continuous > change from Auto to Custom > uncheck use continuous scale.
Regards,
Prashant Sangle
have you checked "suppress zero values" option