Excel Scatter Chart

Hi All,

I have been looking to reproduce a specific type of chart for the past couple of months, but the way is somewhat hard... you may help me..

Below you will find it… It has just two pieces of information… how something was a week ago, and how it is now… (in this case is related to financial markets). I really don’t know how to do it… but I think that is some kind of scatter points chart... or related to it at least ...

As an example, take a look at line 7, where we can find some information about France…. The “chart” shows that one week ago it was at “OS” (light green) and now it is at “N”

Any thoughts?

untitled.jpg

You should be able to build that using xy-scatter series, one series for red and green dots. Use custom X error bar values to drawn the lines extending out from each data point.