Get instant live Excel expert help and learn how to make a Pivot Table

Color changing charts based off of weight goals for the day and week. every week the goal weight will change. also how to use pivot tables and graphs that update automatically from that. etc.

Currently using an excel spread sheet to create a database of parts and their parts numbers, as well as the contact information of who to contact to order the part. I have a pivet table set up and in column A i have all the parts going down, and then the plus/minus buttons are clicked to reveal the contacts/phone/email to get ahold of it, again this is all in column A via the compact form report layout. Next i am trying to find a way to insert addition information such as order frequency etc, in column BCDEF. I want them to be attached to the pivot table so that i can easily update and insert information. If i were to insert the frequencies next to the table but not in it, when opening the plus/minus' in column A this then throws the rest of the document out of wack and isnt aligned correctly. How would i go about inserting this information in a column connected to the pivot table and its corresponding parts without changing out of the compact view because of printing aspects and clarity.

Need to update several pivot tables in a worksheet after the data is updated (data is a OBDC query)

Adding script to update data source of multiple pivot tables

Updating data ranges for multiple pivot tables in one update.

Every month we copy the worksheet we are working on over, rename the worksheet for the current month, update the figures, and then update the pivot table on that worksheet to pull from the new figures. For some reason, this no longer works. We tell the worksheet to pull from July's tab and then hit refresh, but it's still pulling from June.

A coworker tried to update the account names in my pivot table. Somehow she added a 2 to the end of all these Microsoft accounts. It causes my 4 week average formula to stop working, since it references the account name. These are all the #NA's you see in the right column. How can I edit the name back to the original so the formulas work again? I just need to remove the 2's from the end of each name. Thanks

I have two separate pivot tables, with the same data source, I want to use a cell value to update filters for different pivot fields from this one cell value. I need to be able to do this same operation on the work sheet for 3 or 4 cells. Filter by Month then year and by customer name.

I need excel pivot table help! Cannot update the latest entered data on my pivot tables

During the preparing of pivot table, I have a problem to update the pivot table every second so need the shortcut key.