I am doing industry analysis, and this is what I am trying to do
1) Calculate performance ratio for each of the player in the industry. There
are 20 players, and i am measuring them on 18 criterion
2) I am doing the same calculations as above for whole industry
3) I have to benchmark each player against industry and draw different
graphs for that, mostly bar graphs.
Question: Is there a way thay I can automate this process so that data get
pulled on its own for each company against industry, so that i dont have to
draw graph for each company separtely each time?

Check out the dashboards at http://ExcelUser.com

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

"Rajeev" wrote in message
...
I am doing industry analysis, and this is what I am trying to do
1) Calculate performance ratio for each of the player in the industry.
There
are 20 players, and i am measuring them on 18 criterion
2) I am doing the same calculations as above for whole industry
3) I have to benchmark each player against industry and draw different
graphs for that, mostly bar graphs.
Question: Is there a way thay I can automate this process so that data get
pulled on its own for each company against industry, so that i dont have
to
draw graph for each company separtely each time?

Make it into a pivot chart? (Data menu, pivot table/chart command)

"Rajeev" wrote:

I am doing industry analysis, and this is what I am trying to do
1) Calculate performance ratio for each of the player in the industry. There
are 20 players, and i am measuring them on 18 criterion
2) I am doing the same calculations as above for whole industry
3) I have to benchmark each player against industry and draw different
graphs for that, mostly bar graphs.
Question: Is there a way thay I can automate this process so that data get
pulled on its own for each company against industry, so that i dont have to
draw graph for each company separtely each time?