CODEWITHSUNDEEP
excelplotscatter-plot
Mark K
Mark K

Reputation: 9348

To fix scatter sizes in Excel (scatter plot made from Table)

Small dataset in Excel as a Table. A slicer is added. And, I made a scatter plot from it.

The scatter size is set to larger than default but when I choose from slicer, the size of scatters jumped back to default size (smaller).

For example, Kate's in the screenshot.

What's the way to fix the scatter sizes?

enter image description here

enter image description here

Excel file: Scatter plot.xlsx

enter image description here

Upvotes: 0

Views: 142

Answers (1)

p._phidot_
p._phidot_

Reputation: 1950

Select Kate > Select the graph > Format > Current Selection : Vertical/Horintal Axis > Try Fix the value here (no Auto)

Does it work on ur excel version?

Upvotes: 1

Related Questions