• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automating/templating Pivot Tables And Charts

V

villival

Member
I have a report that I generate in excel on a daily basis. From that one report, I create about 5 pivot tables and charts (kind of time consuming). Is there a way to create a template and simply "drop" the source data into excel on a daily basis and have the pivot tables and charts created automatically?, data wont be same all the day it varies


Thanks!
 
Hi villival,

Yes, it is very much possible..go through the below links containing samples..this will help...

I would suggest to try yourself first and if you face any issues..do show up here with the sample data and the required output, always happy to help.. :)

http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/

http://dedicatedexcel.com/how-to-make-an-excel-pivot-table-update-automatically/

http://blog.infiniteskills.com/2014/12/7-tips-creating-dynamic-dashboards-microsoft-excel/

http://www.techrepublic.com/blog/mi...amic-excel-chart-and-make-your-own-dashboard/

http://www.exceltip.com/excel-dashboards

You can also use insert table option to dynamically define your data ranges..
 
Asheesh,

Thanks for the quick reply, am looking for pivot table with charts guess this will help else wiill get back

Thanks



Asheesh said:
Hi villival,

Yes, it is very much possible..go through the below links containing samples..this will help...

I would suggest to try yourself first and if you face any issues..do show up here with the sample data and the required output, always happy to help.. :)

http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/

http://dedicatedexcel.com/how-to-make-an-excel-pivot-table-update-automatically/

http://blog.infiniteskills.com/2014/12/7-tips-creating-dynamic-dashboards-microsoft-excel/

http://www.techrepublic.com/blog/mi...amic-excel-chart-and-make-your-own-dashboard/

http://www.exceltip.com/excel-dashboards

You can also use insert table option to dynamically define your data ranges..
Click to expand...
Asheesh said:
Hi villival,

Yes, it is very much possible..go through the below links containing samples..this will help...

I would suggest to try yourself first and if you face any issues..do show up here with the sample data and the required output, always happy to help.. :)

http://chandoo.org/wp/2010/12/08/dynamic-dashboard-video-tutorial/

http://dedicatedexcel.com/how-to-make-an-excel-pivot-table-update-automatically/

http://blog.infiniteskills.com/2014/12/7-tips-creating-dynamic-dashboards-microsoft-excel/

http://www.techrepublic.com/blog/mi...amic-excel-chart-and-make-your-own-dashboard/

http://www.exceltip.com/excel-dashboards

You can also use insert table option to dynamically define your data ranges..
Click to expand...
 
@Asheesh OP informed by conversation the benefits of starting a new post.

Conversation contents:-

You have asked a slightly different question in this thread about templates, no matter how similar a question may be you should always start a new post for various reasons.

1/ Those that have helped will think they have done all they can and may not revisit.

2/ Those who have visited but where not able to offer any help BUT could have helped your last post may not revisit

3/ Any help received will not show up in a search as you have buried your question in another post.

New question, no matter how similar should have a new post with a clear title.


.
 
You must log in or register to reply here.
Back
Top