Excel Graph Data always resets on reopening

chrono2483

Board Regular
Joined
Aug 23, 2014
Messages
157
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?
 

Forum statistics

Threads
1,085,850
Messages
5,386,342
Members
401,996
Latest member
mg07p929

Some videos you may like

This Week's Hot Topics

Top