Forum Discussion
Jake97
Mar 27, 2021Copper Contributor
Help with legend in excel chart
I need help with a contour chart in excel. My chart is displaying temperatures from my data. The contour chart has a legend which shows different value ranges and is represented by a color in the cha...
Riny_van_Eekelen
Mar 27, 2021Platinum Contributor
Jake97 Try this:
First create a 3-D surface chart and set set the vertical axis to go from 40 to 90 and choose 5 as the major unit. Now change the chart type to a 2-D surface. Created the chart in the picture below on a Mac, with a setting from 9 to 25 and major units of 2. Should work similar on Excel for Windows.
And this is how it looks with the default settings: