How to put labels at bottom of scatter chart excel

#How to put labels at bottom of scatter chart excel how to

Scatter chart is used to display the actual data point, while bar chart is to display Grade labels.

Since Excel allows different chart types to be displayed in one chart, we are going to create a mix of bar chart (column chart) and scatter chart. In Mapping table, put a dummy 0 for Y axis. In Data Source table, vlookup up РІР‚СљOrderРІР‚Сњ from РІР‚СљMapping TableРІР‚Сњ, we are going to use this Order value as x-axis value instead of using Grade. To group Grade text (ordinal data), prepare two tables:Р”Сћ) a mapping table indicating the desired order in X-axis Solution РІР‚вЂњ Excel scatter chart using text name Therefore in the below scattered chart, we see 10 data points. If we put text name in x axis (Grade), in order to force text name to become numeric, Excel converts first x value (Grade 1) to numeric value 1, the 2nd x value (Grade 3) to numeric value 2, and so on. Sometimes we categorize x axis values as a group name (ordinal data) instead of providing the actual numeric value. From the graph, you can see the trend that Salary increases exponentially with Grade (although the data is dummy, the trend is real). Excel scatter chart using text nameР”В®xcel scatter chart requires the x axis and y axis for each data point to be plotted in a diagram, and then join all those point together to analyze the trend or analyze if x and y variables are correlated, where X and Y values have to be numeric values.Р”В«elow is an example showing how employee Grade is related to salary.

#How to put labels at bottom of scatter chart excel how to

This Excel tutorial explains how to ordinal data (text) in scatter chart using bar chart.