Scatter Plot/Chart Resizing

%3CLINGO-SUB%20id%3D%22lingo-sub-2726762%22%20slang%3D%22en-US%22%3EScatter%20Plot%2FChart%20Resizing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726762%22%20slang%3D%22en-US%22%3EHi%2C%20my%20scatter%20plot%20is%20attached%20to%20a%20table%20and%20next%20to%20the%20table.%20But%20when%20I%20filter%20on%20the%20table%2C%20because%20the%20cells%20disappear%2C%20the%20scatter%20plot%20size%20changes%20and%20shrinks.%20Is%20there%20any%20way%20I%20can%20lock%20the%20size%20of%20the%20chart%20so%20it%20doesn%E2%80%99t%20change%20with%20the%20cells.%20For%20some%20reason%20under%20properties%2C%20I%20can%E2%80%99t%20select%20any%20boxes%20where%20it%20says%20%E2%80%9Cdon%E2%80%99t%20change%20chart%20area%20with%20cells%E2%80%9D%2C%20those%20options%20are%20grayed%20out.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2726762%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
Hi, my scatter plot is attached to a table and next to the table. But when I filter on the table, because the cells disappear, the scatter plot size changes and shrinks. Is there any way I can lock the size of the chart so it doesn’t change with the cells. For some reason under properties, I can’t select any boxes where it says “don’t change chart area with cells”, those options are grayed out.
1 Reply

@Ausharma05 You can set the Chart Area properties to move and/or size with cell (see picture below).

 

Screenshot 2021-09-07 at 05.54.09.png

Picture take in a Mac but it's similar on the PC.