In the Format Data Point pane, click the "Fill and Line" paint pot, and in the Fill section, check "Solid fill," and change ...
To clean up the messy data, it needs to be loaded into the Power Query Editor.