How to Create Excel 2010 Scatter Chart with Text Values

microsoft-excel microsoft-excel-2010 charts

Solution 1:

You can do this-but not directly. Excel cannot plot "letters" in a scatter (xy) chart. However, it is easy to get around this limitation by assigning a numeric value to each letter/non-numeric value you want plotted.

So, in you example, add a column and fill it with values where A=1, B=2, C=3, D=4 and then use the numeric value for your Y (vertical) values.

Your chart would then match your example:

xy_letters

Related

My windows 7 downloads files with appended lines
No restore option with Clonezilla
IIS Express returns HTTP Error 400 after calling from Ubuntu WSL
Windows 10 desktop Bluetooth headset not recognized as such
How to calculate all possible combinations of 1 to n variables taking 2 values
Show that $\sum_{k=1}^n \binom{n}{k}k^2=n^2\cdot \:2^{n-2}+n\cdot \:2^{n-2}$.
Strong convexity of Loss function in Logistic Regression
Why $c_1 ^{\omicron(\sigma)} = c_1 \implies c_1(\tau _1) = \tau_1 $ etc.
Show that there exists a regular function that is not a quotient of polynomials
Show that the Absolute Value Function Is not Rational
Convex Optimization Problem (example)
If $f \in \mathcal{R}[a, b]$ and $f(x) \geq 0$ almost everywhere, prove that $\int^b_a f\geq 0$