Forum Discussion
How to overlay a line chart with secondary data
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...
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.
JKPieterse Thanks a ton for your help! That worked perfectly and was a much simpler solution than I expected!