Thread: Scatter Chart

Hi, maybe if you set the Y axis to logarithmic scale?

Here is a tutorial by Tushar Mehta: http://www.tushar-mehta.com/excel/ne...cale/help.html

hth

Maybe you need to take a step back and think about what the chart should actually show.

Do you really need all countries visible at all times? If so, you need to fine tune your parameters for the Y axis, so the values are easier to distinguish, and make the chart really, really tall

Maybe you need several charts to display all the information. One for each bandwidth area, e.g. one for the countries in the 100 -1000 range, another one for the 1000 to 10,000 range and a third one for the big players.

Maybe you want to highlight just a single country, or let the user select a country to focus on? Then you need an interactive chart solution. Very good examples and tutorials can be found on Jon Peltier's site www.peltiertech.com

Here is an article about letting the user choose which data series to highlight:

http://peltiertech.com/Excel/Charts/ParallelCoord.html

The following article shows how to adjust the Y axis depending on a cell value. It requires some VBA, but Jon supplies all you need.

http://peltiertech.com/Excel/Charts/...nkToSheet.html

Maybe, after studying these approaches, you can come up with a combined approach, where the user selects several countries to highlight in the overall chart, and the axis scale is adjusted to the selected country/countries.

Think outside of the box!

hth