Forum Discussion

Jake97's avatar
Jake97
Copper Contributor
Mar 27, 2021

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 chart. The temperatures in my data range from 40 to about 90 degrees, but the legend that is automatically created for my chart, shots ranges for 0-20 and 20-40 degrees. I need to display at least 8 different colors on my chart and I want the legend to have a color associated with each of the following temperature ranges: 40-45, 45-50, 50-55, 55-60, 65-70, 70-75, 75-80, 85-90. I attached a picture of my chart. Please let me know if you can help. Thanks. 

Charting
excel

2 Replies

  • Justin__B's avatar
    Justin__B
    Copper Contributor
    Oct 17, 2023

    Jake97 

     

    There is a much easier way:

     

    select the chart > format > format axis > axis options > Units "Major" > input your desired value

     

    The ranges will update to intervals matching the major units.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 27, 2021

    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:

Resources