Excel Min Max Diagramm. Otherwise column c contains the n a error value which is not plotted with a marker in an excel scatter or line chart. The secondary axis min value is 33 201 and the max value is 42 201 those results are correct based on the data.
Fix the horizontal axis. Make sure you are within the axis options section of the format axis pane. Select the data in cells b40 e64 insert a 2 d column chart step 2.
So the formulas appear to be working properly because the min and max values on each axis are correct but the secondary line is still not appearing.
Otherwise column c contains the n a error value which is not plotted with a marker in an excel scatter or line chart. Otherwise column c contains the n a error value which is not plotted with a marker in an excel scatter or line chart. Right click the highlighted y axis and select format axis. Within the bounds section manually input your minimum and maximum axis limits.
