Scatter Chart

patyandra

New Member
Joined
Nov 20, 2009
Messages
10
Hello,
I want to create a scatter chart using an Excel table that contains milions euro, years (2000-2008) and the 27 countries from EU. I thought about a scatter chart (my finance teacher recomended that) butI have a problem with my values. On the chart we can see countries with large values and their evolution, but the other countries with small and almost the same values are all in the same place. Can I make a better scatter chart? If not, could you recommend another type of chart for my data?:confused:

Here is my table and chart
ftputw.jpg


thanks and sorry for my english :D
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
What you could try is to format the Y-axis and set it to logarithmic. That will spread the lower region better. Of course then the reader will need to understand this scale.
 

Jobowo

Board Regular
Joined
Oct 21, 2009
Messages
242
Only a weak alternative: plot a second chart for "smaller scale" economies. A secondary axis on the same chart for the small economies would be a confusing mess.
 

patyandra

New Member
Joined
Nov 20, 2009
Messages
10
thank you very much for your assistance
I tried the logarithmic scale, base 10, but I have the same problem...
fvcpk5.jpg


maybe because many countries have similar values and that is why my chart looks like that..
 

patyandra

New Member
Joined
Nov 20, 2009
Messages
10
Only a weak alternative: plot a second chart for "smaller scale" economies. A secondary axis on the same chart for the small economies would be a confusing mess.


I thought about that, but in my assignment I really have to use one chart. If I can't find another way, I will create 2 charts.

Thank you!
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
You may want to create a "break" in the y axis. See
http://www.tushar-mehta.com/excel/newsgroups/broken_y_axis/tutorial/index.html

Jon Peltier and/or Andy Pope have a similar tutorial on their respective web sites: www.peltiertech.com and www.andypope.info
Hello,
I want to create a scatter chart using an Excel table that contains milions euro, years (2000-2008) and the 27 countries from EU. I thought about a scatter chart (my finance teacher recomended that) butI have a problem with my values. On the chart we can see countries with large values and their evolution, but the other countries with small and almost the same values are all in the same place. Can I make a better scatter chart? If not, could you recommend another type of chart for my data?:confused:

Here is my table and chart{snip of large image}
 

Watch MrExcel Video

Forum statistics

Threads
1,122,803
Messages
5,598,131
Members
414,214
Latest member
marketingnumbersguy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top