Here is where Excel pivot tables step in to extract data ... You can right-click on a chart to change the fill and outline ...