Data on excel table not showing

%3CLINGO-SUB%20id%3D%22lingo-sub-1288442%22%20slang%3D%22en-US%22%3EData%20on%20excel%20table%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1288442%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20there%2C%3C%2FP%3E%3CP%3EI've%20got%20a%20funnel%20chart%20which%20isn't%20showing%20all%20of%20the%20information.%20It%20is%20linked%20to%20a%20pivot%20table%20which%20has%20three%20columns%2C%20time%2C%20male%20and%20female%20(it%20is%20showing%20the%20times%20that%20males%20and%20females%20bought%20something).%20I'm%20adding%20a%20funnel%20chart%20which%20I%20was%20hoping%20would%20display%20all%20the%20information%20but%20only%20the%20female%20information%20on%20the%20funnel%20chart%20is%20showing%20and%20not%20the%20male%20information.%3C%2FP%3E%3CP%3EI%20tried%20with%20a%20normal%20column%20chart%20and%20all%20the%20information%20showed%20however%20in%20the%20funnel%20chart%2C%20only%20the%20female%20information%20was%20showing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20added%20a%20legend%20and%20it%20still%20said%20that%20only%20the%20female%20information%20was%20showing%20and%20not%20the%20male%20information.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFind%20below%20the%20attached%20file%20(go%20to%20prototypes%20and%20attempt%20to%20add%20a%20funnel%20chart%20with%20the%20hours%2C%20female%20and%20male%20information).%20(The%20content%20isn't%20real%2C%20it%20is%20from%20Mockaroo)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%2C%3C%2FP%3E%3CP%3Eany%20input%20is%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1288442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289398%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20on%20excel%20table%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612496%22%20target%3D%22_blank%22%3E%40alexanderluong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFunnel%20chart%20shows%20one%20series%20at%20a%20time.%20You%20may%20generate%20two%20funnel%20charts%20for%20each%20series%2C%20adjust%20transparency%20and%20overlap%20one%20over%20another.%20However%2C%20not%20sure%20that%20will%20be%20a%20good%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hey there,

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)

 

Thank you so much,

any input is appreciated!

 

 

 

 

1 Reply
Highlighted

@alexanderluong 

Funnel chart shows one series at a time. You may generate two funnel charts for each series, adjust transparency and overlap one over another. However, not sure that will be a good result.