Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi Victoria,
Thanks for your understanding.
Best Regards,
Hugo
Chart data source selection changes when the file is edited from Excel Online
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have an Excel workbook containing a sheet of various charts that are locked for editing. The data for the charts comes from other sheets in the workbook which are editable by other users (they can only input data into certain unlocked cells). Whenever other sheets in the file are edited, the data source selection for Horizontal (Category) Axis Labels changes and selects boxes that were previously unchecked. This happens with a number of charts, even when data has not been input into the data source range for a particular chart. Is there a way to preserve the axis selections as I am having to continually edit the file to revert the data selection back to what it should be. Thanks.
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
12 answers
Sort by: Most helpful
-
Anonymous
2019-11-01T14:15:48+00:00 -
Anonymous
2019-11-01T14:08:49+00:00 Hi Hugo,
Many thanks for the update and providing the issue summary. I'll follow your suggestion and create a ticket with the Office 365 Admin centre.
Kind regards,
Victoria