Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting a chart
Hello,
I have a user who sent this request: "Can you think of any way to draw the following kind of graph? Horizontal axis = X, vertical axis = Y. I want to plot 20 nations by X and Y. Each nation is plotted for two years, 1980 and 2005. Thus there would be 40 points on the graph, two for each nations (one for 1980, the other for 2005). Id like the graph to show an arrow for each nation, running from its 1980 coordinates to its 2005 coordinates. It would be nice to label each arrow with the name of the nation." Here is an example of the data he is trying to plot: Iceland Iceland Norway Norway Australia Australia 1980 2005 1980 2005 1980 2005 X 17 20 43 48 35 41 Y 5 7 8 12 9 15 I do not have that much experience with charts, and don't know how to set this up. Can anyone point me in the right direction, based on the information provided above? We are using Excel 2007. Thanks so much!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Plotting a chart
Make a chart with two XY series, one for 1980 and the other for 2005. Then
connect them with arrows as described in my blog: http://peltiertech.com/WordPress/200...th-arrows-vba/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Tammy" wrote in message ... Hello, I have a user who sent this request: "Can you think of any way to draw the following kind of graph? Horizontal axis = X, vertical axis = Y. I want to plot 20 nations by X and Y. Each nation is plotted for two years, 1980 and 2005. Thus there would be 40 points on the graph, two for each nations (one for 1980, the other for 2005). I'd like the graph to show an arrow for each nation, running from its 1980 coordinates to its 2005 coordinates. It would be nice to label each arrow with the name of the nation." Here is an example of the data he is trying to plot: Iceland Iceland Norway Norway Australia Australia 1980 2005 1980 2005 1980 2005 X 17 20 43 48 35 41 Y 5 7 8 12 9 15 I do not have that much experience with charts, and don't know how to set this up. Can anyone point me in the right direction, based on the information provided above? We are using Excel 2007. Thanks so much!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting A Chart From One Variable | Charts and Charting in Excel | |||
Bubble Chart Plotting | Charts and Charting in Excel | |||
Plotting a diagonal in a bubble chart | Charts and Charting in Excel | |||
Plotting 4 dimensions in a chart | Charts and Charting in Excel | |||
scatter chart insists on plotting as a line chart | New Users to Excel |