Hi,
I'm trying to plot Scatter line chart rankings for 3 years. Rankings are like "A+,A,B+,B,C" but instead of these text values numbers appearing.
Attached the same workbook, appreciate your support to resolve this..
Regards,
Nawas
Hi,
I'm trying to plot Scatter line chart rankings for 3 years. Rankings are like "A+,A,B+,B,C" but instead of these text values numbers appearing.
Attached the same workbook, appreciate your support to resolve this..
Regards,
Nawas
A scatter chart needs numbers for the horizontal x axis, so it interprets text as numbers. When you want text/categories along the x axis, you can try a line chart instead of xy scatter.
Select the chart -> change chart type -> line and see if that is what you are looking for.
Originally Posted by shg
Thanks for your reply, but i'm looking for Bell Curve chart and in line chart the shape of the bell curve will not be the perfect.
As Mr Shorty suggested use a line chart, smooth lines and horizontal axis labels on tick marks.
If the letters are not equally spaced then you can create additional series with the correct x and y value for each letter and use a data label showing series name in order to fake an textual axis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks