chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
Hello,
I have an odd situation, that I hope can be fixed vs. just an excel glitch.
I have a table with data. From this data, I have several column charts created, representing the WoW data. When I go into Select Data Source, on the left (Legend Entries) I have the 4 locations, on the right (Horizontal Axis Label) I have the 4 weeks. However, also on the right are several blank boxes/spaces. Based on the source data, these need to remain, however I am able to uncheck them, so they are not visible on my graph.
All displays well and as intended. However when I close the sheet, and reopen - the selections reset and I have to uncheck the blank boxes in Select Data Source again.
Is there anything to do to lock it so it does not revert to the original state?
I have an odd situation, that I hope can be fixed vs. just an excel glitch.
I have a table with data. From this data, I have several column charts created, representing the WoW data. When I go into Select Data Source, on the left (Legend Entries) I have the 4 locations, on the right (Horizontal Axis Label) I have the 4 weeks. However, also on the right are several blank boxes/spaces. Based on the source data, these need to remain, however I am able to uncheck them, so they are not visible on my graph.
All displays well and as intended. However when I close the sheet, and reopen - the selections reset and I have to uncheck the blank boxes in Select Data Source again.
Is there anything to do to lock it so it does not revert to the original state?