how to plot a graph in excel coordinates x y

Also, I personally rarely come across a dataset that lends itself to a good parallel coordinates graphs. The categories are nominal and can be reordered, changing the shape of each series. If parallel coordinates can work so well, why do we see them so seldom? First, they have the counterintuitive feature that lines (series) do not represent a progression. The other countries are in shades of gray, with minimal differentiation, because they are only relevant in their position relative to Nigeria. The reader is no longer invited to parse the entire data set to find something of relevance: the graph makes it clear and corresponds to the accompanying text. On a parallel coordinates graph though it becomes quite clear where Nigeria stands against other countries:īy highlighting Nigeria, the message becomes clearly visible. The bar graph does not show clearly that costs in Nigeria are lower across professions than in most other markets. At N2,500 or US$16 per day (US$2 per hour) for artisans and N1,500 or US$10 per day (US$1.25 per hour) for laborers, labor rates in Nigeria appear to be low in comparison with competitor countries (Figure 5). But reading the text, it appears that the goal is to compare Nigeria against other countries for each profession, and not across professions. At first, this seems like a good opportunity for small multiples, with either jobs or country groupings. This graph shows all the data but it is difficult to read, let alone to see how any given country compares.

Each country is represented by a color, in default Excel fashion. This graph is meant to show how wages in Nigeria compare to other countries across several professions related to the housing market.

How to plot a graph in excel coordinates x y