LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 145
Default Plotting a chart

Hello,

I posted this question on 1/8/09, but can't find it, and haven't received a
response, so, now I'm wondering it I ever actually sent it, or possibly
posted it to the wrong group...

I have a user who sent me 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.

Any ideas?"

Here is a sample of his data:

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 have only "basic" chart experience, and can't figure out how to even get
started arranging his data properly.

Does anyone know how we can achieve what he'd like to do?

Thanks for any suggestions to get us started.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plotting a chart Tammy Charts and Charting in Excel 1 January 8th 09 10:23 PM
Plotting A Chart From One Variable Alectrical Charts and Charting in Excel 10 August 14th 07 03:36 PM
Bubble Chart Plotting stephenclark Charts and Charting in Excel 1 January 10th 06 07:49 PM
Plotting 4 dimensions in a chart Garam Chitti Charts and Charting in Excel 1 June 10th 05 12:31 PM
scatter chart insists on plotting as a line chart Knows too little New Users to Excel 0 March 11th 05 06:37 PM


All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"