Macro Chart

[gabrielcardier]

Hello, I would like to create a Macro Chart with the info shown attached.


ESTADO PRODUCTO CIUDADALPHA TIPODESPACHO 16
AMAZONAS203020 PUERTO AYACUCHO ENTREGADO 1
AMAZONAS 203023 PUERTO AYACUCHO ENTREGADO 7
AMAZONAS 203024 PUERTO AYACUCHO ENTREGADO 1
AMAZONAS 203025 PUERTO AYACUCHO ENTREGADO 3
AMAZONAS 203037 PUERTO AYACUCHO ENTREGADO 3
AMAZONAS 203038 PUERTO AYACUCHO ENTREGADO 3
AMAZONAS 203044 PUERTO AYACUCHO RETIRADO 3
AMAZONAS 203045 PUERTO AYACUCHO RETIRADO 0
AMAZONAS 203079 PUERTO AYACUCHO ENTREGADO 1
AMAZONAS 203080 PUERTO AYACUCHO ENTREGADO 1
AMAZONAS 203131 PUERTO AYACUCHO ENTREGADO 0
AMAZONAS 203132 PUERTO AYACUCHO ENTREGADO 0
AMAZONAS 203223 PUERTO AYACUCHO ENTREGADO 0

Where Estado= State; Producto=Product; Ciudadalpha=City;Tipodespacho=Delivery;16, 17, 18, 19 = Sales per Week. I'm looking for a chart thath shows The amount of sales per state, product, city, delivery. I find the info very extensive and there fore i dont know how to create a decent chart to show the specified info in a coherent way.

Please help me out.

 

[MGumbrell]

Sounds as though you need a Pivot Table. Unfortunately my knoweledge of Pivot Tables ends with there use. I have yet to create one myself but believe that this would be your best option.

Matt

 

[shades]

Howdy. Yes, Pivot tables could solve what you need. And if you need a chart, you make a Pivot chart as well.
________
Chrysler Ja Platform