Automatic chart generator

M

mbobro

Hi,

I need to analyze the Excel data.
The raw data incluse six tables that are time series (around 5
measurements) for around 100 subject each.

Having that I should calculate some easy formulas based on that data.

I'd like to illustrate the results using MS charts. Moreover it will b
useful for data entering validation.

What I was planning to do was to prepare some links for predefine
charts that should be interesting for me.

The more flexible step was to make Excel create the charts out of ra
data. I feel it will consume lots of work while programming VBA. Mayb
I should use pivot tables there. I think I'm able to do this, althoug
it will rather not develop much my programming skills.

The last option I'd like to ask you is a kind of Add-in or externa
program that will ease me producing the charts. Does anyone coul
recommend me such a solution?

The solution should have a were good formatting abilities, as it i
possible I will publish the charts.

How would you approach this issue in general?


Thanks,


Micha
 
V

Vaughan

Any chart you create in excel should automatically update for changes to the data. You won't need to program anything, but I would need to know more about what you want to do to be more help.
 
M

mbobro

Ok,

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

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

I have all these data gathered in 6 tables - for example one fo
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 compar
countries on some time periods. I need to compare different counties o
the specific year. I want to calculate the GDP per capita and sort th
countries in ascending order. I want to find some correlations. I nee
to group the countries and years and analyze groups.

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

I was asking about a kind of generic tool that will, for exampl
generate series of identical GDP time series charts for each individua
country with one click. If I calculate the GDP per capita I need a too
that once I ask for France it will find itself the proper rows i
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 tha
is 'generic' table -> chart generator that may save me lots of hour
programming.

I hope now it is more clear :)



Micha
 
J

Jon Peltier

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/
_______
 
Top