Automatic chart generator

Michal -

I have some suggestions on this web page that would make it easier to
select which data to chart:

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

You could make two combo boxes, and select one country in each, in order
to compare them. Or you could put multiple checkboxes, and check the two
or more you'd like to compare.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

mbobro wrote:

Ok,

There are some additional info on how I need the 'automatic chart
generator' to act.

Imagine I have 100 coutries. Each country is described with 6 features
(for example population, GDP) measured each year for last 50 years.

I have all these data gathered in 6 tables - for example one for
population data for all countries for last 50 years, other for GDP,
etc.

Once I have these data I need to analyze it. I need to compare
countries on some time periods. I need to compare different counties on
the specific year. I want to calculate the GDP per capita and sort the
countries in ascending order. I want to find some correlations. I need
to group the countries and years and analyze groups.

Of course I may make a static charts with links that will take the
value from cell such and such and show it on a chart. But once the
number of years or countries change I'll have to manually update the
links.

I was asking about a kind of generic tool that will, for example
generate series of identical GDP time series charts for each individual
country with one click. If I calculate the GDP per capita I need a tool
that once I ask for France it will find itself the proper rows in
tables where GDP and population are stored.

I know I can do it programming myself for this individual purpose.

I was asking whether there is a kind of add-in or external program that
is 'generic' table - chart generator that may save me lots of hours
programming.

I hope now it is more clear



Michal


---
Message posted from http://www.ExcelForum.com/