Hello,
I have a spreadsheet contains several tables and column charts. Tables link t other worksheets by excel formulas. I have been using this file for a couple of month ad it used to work perfect. Since I have Several tables and charts, It is hard an crowded to make a presentation with the file. So, I added a few macros to the file. Each macro hides all tables and charts except the one I want to present. Each chart is linked o its reference table that both will be visible simultaneously. There I no link between a chart while It is visible with a hidden table. The issue is that when I run one macro, chart horizontal axis label change to numbers 1,2,3,... . I checked the chart data, and found that it is ok. Even though the axis label is correct and visible, It is not displaying it. Instead of label text, it is showing numbers starts with 1. I changed the horizontal axis label setting from automatic to both data and text, removed old data reference and defined new series, however, I have the same problem. Can anybody help e with the issue? your kind attention will be highly appreciated.
Thanks in advance
I have a spreadsheet contains several tables and column charts. Tables link t other worksheets by excel formulas. I have been using this file for a couple of month ad it used to work perfect. Since I have Several tables and charts, It is hard an crowded to make a presentation with the file. So, I added a few macros to the file. Each macro hides all tables and charts except the one I want to present. Each chart is linked o its reference table that both will be visible simultaneously. There I no link between a chart while It is visible with a hidden table. The issue is that when I run one macro, chart horizontal axis label change to numbers 1,2,3,... . I checked the chart data, and found that it is ok. Even though the axis label is correct and visible, It is not displaying it. Instead of label text, it is showing numbers starts with 1. I changed the horizontal axis label setting from automatic to both data and text, removed old data reference and defined new series, however, I have the same problem. Can anybody help e with the issue? your kind attention will be highly appreciated.
Thanks in advance
