Enable Chart Tool options by clicking anywhere within an Excel 2007 or 2010 chart whose information you want to modify. Click Design on the main menu, then Layout and finally, select Axis Title or ...

Then click the paintbrush to change the chart’s design. 011 Select Database and insert the Box & Whisker Chart. 3. Right-click any of the rectangles on the chart and select Format Data Series. 4.