Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a dataset and pivot tables. Charts not changing when downloaded on a different computer
Solved by Z. D. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 31/03/2018 - 03:26
Hi
Excelchat Expert 31/03/2018 - 03:27
Hi
Excelchat Expert 31/03/2018 - 03:27
Wecome to got it pro!
User 31/03/2018 - 03:27
I have created charts based on pivot tables and slicers
User 31/03/2018 - 03:27
But when i download the same chart on a different computer
Excelchat Expert 31/03/2018 - 03:27
Ok
User 31/03/2018 - 03:27
Its not working
Excelchat Expert 31/03/2018 - 03:27
Does the chart actual show the graph?
User 31/03/2018 - 03:27
Like the graphs are not chaning
Excelchat Expert 31/03/2018 - 03:27
or it will show empty
User 31/03/2018 - 03:27
changing*
Excelchat Expert 31/03/2018 - 03:27
Ok
User 31/03/2018 - 03:28
It shows values but its static
Excelchat Expert 31/03/2018 - 03:28
does the graph including the same data range ?
User 31/03/2018 - 03:28
Yeah
Excelchat Expert 31/03/2018 - 03:28
ok
User 31/03/2018 - 03:28
Downloading the same file on another computer
User 31/03/2018 - 03:28
but its not working
Excelchat Expert 31/03/2018 - 03:28
Please allow me few minutes to investigate
User 31/03/2018 - 03:29
On my laptop the charts are changing according to the data in pivot tables
User 31/03/2018 - 03:29
But when i download the same file on another laptop the charts are not changing
Excelchat Expert 31/03/2018 - 03:30
Automatically update changed worksheet values in an existing chart The values in a chart are linked to the worksheet data from which the chart is created. With calculation options set to automatic (in Excel, click File tab > Options > Formulas tab, Calculation Options button), changes that you make to the worksheet data automatically appear in the chart. Note: In Excel 2007, click the Microsoft Office Button Office button image > Excel Options> Formulas > Calculation > Calculation Options. 1. Open the worksheet that contains the data that is plotted in the chart. 2. In the cell that contains the value that you want to change, type a new value. 3. Press ENTER.
Excelchat Expert 31/03/2018 - 03:30
Please try to follow these steps and let me know if this works
User 31/03/2018 - 03:35
I mean the charts are not changing
User 31/03/2018 - 03:35
The pivot table values are changing
Excelchat Expert 31/03/2018 - 03:36
Click the chart for which you want to change the cell range of the source data. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, note the location of the data range, and then click OK. Go to the location of the data range, and click any cell in the data range. On the Insert tab, in the Tables group, click Table.
Excelchat Expert 31/03/2018 - 03:36
Keyboard shortcut : Press CTRL+L or CTRL+T.
Excelchat Expert 31/03/2018 - 03:37
If that is the case, then you might need to follow these steps to see if it changes

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.