Data Analysis and Graphs

R

Rajeev

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart question 6
Color coding data in line graphs 1
using two graphs to draw a third. 8
Populating entire rows of data from a master sheet? 3
Multiple Data Representation on Graphs 0
Line graphs where data comes from formulas. 6
graphs from worksheet 0
How do I easily view trends over categories in my data 1

Top