[0]! inplace of workbook name

S

shafiq_eng

New Member
Joined
Oct 6, 2004
Messages
36
Hi,

I have excel graphs linked to dynamic ranges. But x-axis and y-axis range values are showing [0]! in place of workbook names along with range name. The data is also not updating. Any idea about the problem?

shafiq
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

Ironman
  • Question
Chart - Pace won't display correctly on Y Axis
Replies
6
Views
549
Ironman
Ironman
N
  • Solved
Adding to table rows whilst keeping my chart dynamic.
Replies
4
Views
894
Peter_SSs
Peter_SSs
M
  • Question
Horizontal axis automatically starting with earliest date in Gannt chart
Replies
1
Views
344
Dan_W
D
T
  • Question
Vertical gridlines in multi-level category chart Excel 2013
Replies
0
Views
572
trpltongue
T
B
  • Question
Virtual 3rd axis
Replies
0
Views
218
Bostjan ISE
B

Forum statistics

Threads
1,191,353
Messages
5,986,162
Members
440,007
Latest member
cjw29209

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top