CODEWITHSUNDEEP
excelplotgraph
panc_fab
panc_fab

Reputation: 530

plot excel graph with non-numerical values

I'm a quite new Microsoft's excel user, and I'm stuck plotting a graph. It is a graph containing as X values a couple month-year and as Y values, different smartphone screen resolutions. I want to plot a graph representing the evolution, during years, of screen resolutions.

My problem is that I cannot plot nothing because excel doesn't recognise (obviously) numeric values, because resolutions are wrote like 1024x768 etc.

How can I create a graph with these requirements? Googling hasn't give me solutions for now.

thank you guys in advance!

EDIT

Here you are with a sample of data: I want to use "Years" column as values on the x-axis (ordered from the oldest date) and the "Resolution" field on the y-axis, to highlight how screen resolutions evolved during years.

Thank you!

Upvotes: 0

Views: 1971

Answers (1)

Tom Sharpe
Tom Sharpe

Reputation: 34220

As mentioned in the comments I have used the following formula to get the year (it looks like text, I can't really tell)

=RIGHT(A2,4)+(LEFT(A2,2)-1)/12

and this to get the number of pixels in millions:-

=LEFT(E2,FIND("x",E2)-1)*RIGHT(E2,LEN(E2)-FIND("x",E2))/10^6

and when you use a scatter it ends up looking like this:-

enter image description here

Upvotes: 1

Related Questions