Trying to join graph of daily,monthly and type data of production of newspaper

[JOSE COSTA]

Could you help me create this graph report ?
Attached is a dashboard I use to monitor process center production data. Can anyone offer advice to make the dashboard show data weekly monthly and yearly without having to manipulate the data table.

I need to select the month and the graphics will provide me for that month the daily and monthly values of the selected type of graph .

Thank you in advance for any advice and recommendations.

Best regards,

Nildo

 

[Awesome Wally]

For your 2016 and 2015 Graphs you can use a named Range with an Offset Match function. Something like the attached example. I added a bunch of data in your data table to illustrate and removed all the other charts and named ranges (primarily because they are linked to external references).

 

[JOSE COSTA]

Perfect Waily , very grateful because you helped me a lot to develop this first part of the idea. Thank you!
I need just now make a graph of summarized year.
And further improve the presentation to become more professional. You help me with this?
and finally I would like to get through this graphic by email in Outlook every day.

 

[Awesome Wally]

You're welcome. Let me know if you have trouble with the summarized year graphs. You should be able to follow the same logic just add the sum of the daily numbers to your chart and then adjust your offset 32 columns and width to 1.

You can follow the steps here for the email portion: http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/

 

[JOSE COSTA]

I will analyze and then try it so cool , I get that you are beasts in this matter. I 'm starting and nothing better to learn from the good. i will return as soon as possible.