Jan 03 2022 09:03 AM
I created line graphs for mean annual temperatures over two 36-year periods, but would like to combine the two lines (in different colors) on a single graph. The x-axis (years) can remain blank: I'll explain in a caption. The y-axis (Degrees Fahrenheit) needs a range of 42-58.
I use Excel for Mac version 16.56, MacOS Big Sur version 11.6.
Jan 03 2022 09:10 AM - edited Jan 03 2022 09:11 AM
Solution@GGuderian Perhaps something like in the attached workbook?
May 09 2022 10:07 AM
May 09 2022 10:49 AM
@Carpacus If you follow the example in the file I uploaded earlier, create four columns with data and select the whole range, inclusive row and column headers. On the insert ribbon, select the line-chart type and all should come up automatically. If not, perhaps you can upload or share your file (OneDrive, Dropbox or something similar).
May 09 2022 10:52 AM
Jan 03 2022 09:10 AM - edited Jan 03 2022 09:11 AM
Solution