Link to other workbooks

BittenApple
BronzeLounger
Posts: 1459
Joined: 01 Mar 2015, 02:03

Link to other workbooks

Post by BittenApple »

Hello team

I am creating name ranges and when I use them in charts, I see the name of the tab prior to the name of series is changed to something else.
However edit links is inactive.
How to take care of this?
The name of tab is sheet!nameofnameranges is changed to something else.

Regards,
Bita

User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Link to other workbooks

Post by HansV »

What is it changed to?
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1459
Joined: 01 Mar 2015, 02:03

Re: Link to other workbooks

Post by BittenApple »

Hello Hans,

I inserted a chart and started adding name ranges to the chart. But, the name tab with Exclamation sign should be before the name ranges when we want to add a data series to the chart. When I finish adding data to chart, the name of the tab changes to the tab where the data source of pivot table is on.

I hope this makes sense.
I am grateful to you.
Bita

User avatar
HansV
Administrator
Posts: 72885
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Link to other workbooks

Post by HansV »

Could you provide screenshots of "before" and "after"?
Regards,
Hans

BittenApple
BronzeLounger
Posts: 1459
Joined: 01 Mar 2015, 02:03

Re: Link to other workbooks

Post by BittenApple »

Hello Hans,
I don't know what the reason is and perhaps I need more testing. But this is resolved if I make the x-axis static. Excel automatically changes the name of the tab to where the source data is coming from. Once, I made x-axis static, the values are not jammed to one site. But I want to make x-axis dynamic so whenever I don't have values for series, then those series are not displaying on the chart.
Respectfully,
AAusli,