Hello (using excel 2007)
Looking for an alternate way to view Pivot Chart Data Source?
I Cannot see the whole name of the data source when selecting in the chart and clicking 'Select Data'. The Data Source Dialog Box that shows has the field: 'Chart Data Range'. Apparently that field has the data source, but its the fully qualified data source, so includes the name of the file as well as (presumably) the data source in an excel worksheet.
The trouble is the file name is so big it takes up more than the whole field box, so none of the data source range shows up. And there doesn't appear to be any obvious way to expand the field box.
So, short of changing the file name to some short name, is there some other way to access the data source? Note, since its in a pivot chart, the Chart Data Range is greyed out as you can not change this range, so I cannot just select the selection button to see what source it goes to.
Thanks for any suggestions..!![]()
Bookmarks