I've got a funnel chart which isn't showing all of the information. It is linked to a pivot table which has three columns, time, male and female (it is showing the times that males and females bought something). I'm adding a funnel chart which I was hoping would display all the information but only the female information on the funnel chart is showing and not the male information.
I tried with a normal column chart and all the information showed however in the funnel chart, only the female information was showing.
I added a legend and it still said that only the female information was showing and not the male information.
Find below the attached file (go to prototypes and attempt to add a funnel chart with the hours, female and male information). (The content isn't real, it is from Mockaroo)