How to overlay a line chart with secondary data

%3CLINGO-SUB%20id%3D%22lingo-sub-1817561%22%20slang%3D%22en-US%22%3EHow%20to%20overlay%20a%20line%20chart%20with%20secondary%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1817561%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20a%20set%20of%20data%20(simplified%20example%20below)%20that%20I'd%20like%20to%20graph%20by%20year%20and%20then%20have%20the%20different%20'eras'%20shaded%20and%20labels.%20For%20example%2C%20I'd%20want%20to%20have%20the%20GDP%201929-'32%20shaded%20one%20colour%20and%20labelled%20with%20'Hoover'%2C%20and%20the%20GDP%20data%20points%20for%201933-'44%20shaded%20another%20and%20labelled%20with%20'Roosevelt'%2C%20etc.%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-10-26%20at%208.49.51%20am.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229208i0FD931E513C28615%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot%202020-10-26%20at%208.49.51%20am.png%22%20alt%3D%22Screenshot%202020-10-26%20at%208.49.51%20am.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1817561%22%20slang%3D%22en-US%22%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-1818020%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20overlay%20a%20line%20chart%20with%20secondary%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1818020%22%20slang%3D%22en-US%22%3EInsert%20a%20Pivot%20table%20from%20your%20data.%20Drag%20the%20president%20field%20to%20the%20row%20area%20and%20the%20year%20column%20as%20well.%20Then%20drag%20the%20GDP%20field%20to%20the%20sum%20area.%20Click%20Insert%20pivot%20chart.%3C%2FLINGO-BODY%3E
New Contributor

I've a set of data (simplified example below) that I'd like to graph by year and then have the different 'eras' shaded and labels. For example, I'd want to have the GDP 1929-'32 shaded one colour and labelled with 'Hoover', and the GDP data points for 1933-'44 shaded another and labelled with 'Roosevelt', etc.

Thanks for any help!

Screenshot 2020-10-26 at 8.49.51 am.png

2 Replies
Insert a Pivot table from your data. Drag the president field to the row area and the year column as well. Then drag the GDP field to the sum area. Click Insert pivot chart.

@Jan Karel Pieterse Thanks a ton for your help! That worked perfectly and was a much simpler solution than I expected!