Hi, I'm doing a chart trick with text labels and no values. User enters an event into a table, then the text label will appear on the chart (line invisible) . This is to track events for each month.
The problem is when using the Label Options "Value From Cells" option where you select the range. I select the range and it works until I close and open the sheet back up, or at a random time it just stops working so it doesn't display the label. To bring it back I have to "reset label text" button, or reselect the range , which is just pressing ok to refresh it. Any ideas why I can't display text as a chart consistently?
The problem is when using the Label Options "Value From Cells" option where you select the range. I select the range and it works until I close and open the sheet back up, or at a random time it just stops working so it doesn't display the label. To bring it back I have to "reset label text" button, or reselect the range , which is just pressing ok to refresh it. Any ideas why I can't display text as a chart consistently?
