Graphs/Charts

[Gary Schultz]

Can anyone give me some tips on graphing or charting dissimilar data types?

I am trying to correlate how long a process takes to run comparing components of the process. For example: I have a spreasheet that shows dates in column A (DD/MM/YY), time in column B (HH:MM) and various types of transactions in columns C through F. The transactions data is counts ranging from a few hundred to millions and is counts of items or currency.

What is the best way to grahically show how the volume of transactions correlates to the time?

 

[Rasm]

You have to scale you data - so for each variable i.e. currency compute std deviation - then devide each currency value by the std dev. Now it is scaled - do this for each variable - now the have the same variance. You can use the mean instead of the std dev for the purpose of normalizing or scaling you data.

 

[Rasm]

if they are all currencies - but different currencies - then do scaling for each currency

 

[Gary Schultz]

Thanks for the tip! Using the STDDEV function allows me to create the graphs I need!