Cannot Update Chart Data Range!

T

Tfrup12

I have about 35 charts on individual sheets that are all based on their own
PivotTable. I had to save the file to a new location, and when I go to
update the charts in the new location, it appears that each of the charts
maintained the link to the old file, even though the files have the same
name, just different file paths.
To compound the problem, when I right-click on the chart, and try to use
"Select Data...", the "Chart data range:" field is greyed out. How do I get
the charts focused on the new file? ...How do I get my charts to start
working off the new file location?

TIA,
b.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot update "Chart data range:" Field 2
Move Chart with Text 0
Creating a Chart on form from selected data in query. 0
Filtered view of Visio Chart 0
Create a chart from a table in word thats dynamic 0
Automatically shift chart data range 4
Automatically shift chart data range: redux 6
Embed the same Excel multiple times 0

Top