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.
