Excel Dynamic Pivot Table on multi-sheets as per the Attachment.

Check the attachement and the sheet name "Pivot sheet" that picture is my requirment.

Also teach me how to do it.

X axis should be the sheetnames

Y axis is numbers with 10 increments

Graph is 5 parameters with totals on each sheet

As we change the number the graph should automaticaly adjust.

If there are no values or empty sheets the graph should adjust accordingly.

IF there are better ways or ideas for my requirment please advise.

Skills: Excel, Visual Basic, Data Processing, PHP, Software Architecture

See more: excel custom pivot table, excel interop pivot table totals, excel update pivot table odbc, create pivot table from multiple worksheets excel 2010, pivot table multiple sheets google sheets, create pivot table from multiple worksheets excel 2016, create pivot table from multiple worksheets excel 2007, pivot table wizard, how to create multiple sheets from pivot table, create pivot table from multiple worksheets excel 2013, consolidate multiple worksheets into one pivottable, excel 2007 pivot table vsto, vsto excel code pivot table, excel interactive pivot table vbnet, excel 2007 pivot table, excel vbscript pivot table, vsto excel create pivot table vbnet, dynamic pivot table, dynamic pivot table asp net, excel dashboard pivot table chart

About the Employer:
( 9 reviews ) Irving, United States

Project ID: #21169476

Awarded to:


hello sir i can make this pivot chart and also tell you how to do it i am an expert in excel and have done many excel projects in past with excellent ratings so far open a chat session to discuss thank you hope More

$14 USD in 1 day
(78 Reviews)

20 freelancers are bidding on average $28 for this job


Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community (goo.g More

$100 USD in 2 days
(767 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD in 1 day
(360 Reviews)

Dear client I understand what your requirements are. I can help you in that. Kindly contact me for a discussion. Roy

$50 USD in 1 day
(364 Reviews)

Greetings! I do not think that Pivot Table can be used for this scenario (Collating data across dynamic number of sheets) directly. The simplest method that I can think of is using Macros. I can write a macro such tha More

$25 USD in 1 day
(207 Reviews)

Hey Sir, I can do this with the use of macros. The only con is that you have to press a button to re-populate the graph everytime you do a change and the excel file extension will change to Excel Macro-Enabled Workbook More

$30 USD in 1 day
(84 Reviews)

I am good in pivot table, vbscript, powershell script along with automation and development, please let me know if you are good to award this project to me

$29 USD in 2 days
(31 Reviews)

$ 11 Only ----- In just 3 Hours ------ Excel Pivot, Chat, Graph, VBA Macro & Formula Generation Expert ----- 100% satisfaction first, then payment.

$11 USD in 1 day
(89 Reviews)

Hi, I have read the attachment. To get the chart combined from several sheet, there are 2 alternatives that I could suggest: VBA and Power Query. However it will be much easier with VBA if the table format for each sh More

$29 USD in 1 day
(41 Reviews)

Hi Good Day! A serious freelancer here. I want to help you with this Pvot and Chart project. Maybe I can use macro for this. Please consider my bid. I've done a lot of Reports and Templates using MS Excel. I can use More

$30 USD in 2 days
(42 Reviews)

Hello Sir! I am ready to work for you. Just message me to discuss in vreif and let me do for you. I have done same projects before. I am excel expert. I am waiting for you. Thanks.

$10 USD in 1 day
(6 Reviews)

Hi, I have completed a sample work on this pivot table with multiple sheets for you, please have a look into the below file: [login to view URL] I can ex More

$10 USD in 1 day
(7 Reviews)

All already have it done. I would like to show you many ways in which you can organize the data and analyze it, I added some random numbers to see how graphics will behave along time. You would see for example which en More

$30 USD in 1 day
(0 Reviews)

i like to work with you in that project , i type very fast on keyboard what you exactly want will be done quickly in creative ways i have 7 years experience at that field and i can start right now & finish today if po More

$12 USD in 1 day
(0 Reviews)

Don't waste time to read, just accept the lowest bid and experience the expertise in MS excel Pivot tables,Slicers, Macros,Timeliners....etc

$11 USD in 7 days
(0 Reviews)

sir I see your project and I so impressed . I can do that very poorly can you trust me 100%. please get touch with me. thank you

$25 USD in 5 days
(0 Reviews)

I have good knowledge of Excel. I can teach you very well. There are other better option to make pivot table

$20 USD in 1 day
(0 Reviews)

I work on excel(pivot,vlookup, charts, etc.) every day. Along with that, I possess good knowledge about PHP.

$25 USD in 7 days
(0 Reviews)

Hi, I'd be very much interested to help you out today itself and with maximum assistance on whatever medium possible. I'll personally assist you on how tos and whatever additional requirement you might have I can do More

$12 USD in 1 day
(0 Reviews)

Good in excel

$30 USD in 2 days
(0 Reviews)