Help me create sales chart based on state and quantity

  • Thread starter mr_merchant_man
  • Start date
M

mr_merchant_man

We have a production report on excel. It shows the details for our clients.
Part of that data includes the state in which the client lives. We are trying
to create a chart showing the percentages of each state( so we know where the
most deals are closed)

Any suggestions?
 
T

teylyn

Hello mr_merchant_man,

this sounds like a job for a pivot table, using Average as the dat
calculation operator.

Or, depending on your version of Excel, you can use AVERAGEIFS (in Exce
2007) or calculate an averate with a combination of SUMIF divided b
COUNTIF.

To be more specific, it would help to see your data.

cheers, teylyn


We have a production report on excel. It shows the details for ou
clients.
 
Top