To create a chart in an Excel report sheet ... Next, hide the sheets you don't want included in the report. To do this, right-click the sheet tab and select Hide.