Excel 2010 no longer provides the Chart Wizard as you know it. Instead you use the Insert Tab and choose the chart style under the Chart subgroup.  Once the chart is inserted it automatically opens the Chart Tools including Design-Layout-Format tools. 

  • Design Tools - contains Type, Data, Chart Layout, Chart Styles, and Location (lets you move the chart to a new sheet) subgroups. 
  • Layout Tools - contains Current Selection, Insert, Labels, Axes, Background, Analysis, and Properties subgroups.
  • Format Tools - contains Current Selection, Shape Styles, WordArt Styles, Arrange and Size subgroups.

To save a chart as a New Sheet.  Right click on the outer portion of the chart (not on the bars) and choose "Move Chart."