Combination pivot chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2837757%22%20slang%3D%22en-US%22%3ECombination%20pivot%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2837757%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pivot%20table%20summarizing%20different%20work%20centers%20and%20the%20hours%20of%20work%2Fweek%20for%20each%20work%20center.%26nbsp%3B%20I%20also%20have%20columns%20for%20each%20work%20center%20if%20we%20work%2040%20hour%20weeks%2C%2050%20hour%20weeks%20and%2060%20hour%20weeks.%26nbsp%3B%20I%20am%20trying%20to%20create%20either%20a%20chart%20for%20each%20work%20center%20showing%20in%20columns%20the%20total%20hours%20of%20work%20per%20work%20and%20then%20the%20line%20graph%20showing%20our%2040%2C%2050%20and%2060%20hour%20capacities%20or%20trying%20to%20use%20the%20auto%20created%20pivot%20chart.%26nbsp%3B%20I%20do%20like%20the%20filter%20on%20the%20bottom%20left%20of%20the%20auto%20created%20chart%20that%20I%20can%20select%20an%20individual%20work%20center%20but%20then%20the%20line%20graph%20doesn't%20show%20up.%26nbsp%3B%20Any%20help%20on%20solving%20these%20charts%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2837757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2838586%22%20slang%3D%22en-US%22%3ERe%3A%20Combination%20pivot%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2838586%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1182060%22%20target%3D%22_blank%22%3E%40Mike_Paulus91%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20365%20Pro%20Plus%20with%20Power%20Pivot%20and%20Power%20Query.%3C%2FP%3E%3CP%3EWith%20superimposed%20PivotCharts.%3C%2FP%3E%3CP%3ELook%20upon%20it%20and%20despair.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mediafire.com%2Ffile%2Fa37ki7483ymu3s9%2F10_12_21.xlsx%2Ffile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mediafire.com%2Ffile%2Fa37ki7483ymu3s9%2F10_12_21.xlsx%2Ffile%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mediafire.com%2Ffile%2F3cvn6gmi6fsqor6%2F10_12_21.pdf%2Ffile%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mediafire.com%2Ffile%2F3cvn6gmi6fsqor6%2F10_12_21.pdf%2Ffile%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a pivot table summarizing different work centers and the hours of work/week for each work center.  I also have columns for each work center if we work 40 hour weeks, 50 hour weeks and 60 hour weeks.  I am trying to create either a chart for each work center showing in columns the total hours of work per work and then the line graph showing our 40, 50 and 60 hour capacities or trying to use the auto created pivot chart.  I do like the filter on the bottom left of the auto created chart that I can select an individual work center but then the line graph doesn't show up.  Any help on solving these charts would be greatly appreciated.

1 Reply

@Mike_Paulus91 

Excel 365 Pro Plus with Power Pivot and Power Query.

With superimposed PivotCharts.

Look upon it and despair.

https://www.mediafire.com/file/a37ki7483ymu3s9/10_12_21.xlsx/file

https://www.mediafire.com/file/3cvn6gmi6fsqor6/10_12_21.pdf/file