I am finally trying to use the chart feature in Excel 2010. I can create a chart easily in the same worksheet that contains the data. However, when I attempt to create a chart in a new worksheet i get a gray screen. Once I create the chart in the same worksheet as the data I then right click on the chart and click 'Move Chart'. The screen then comes up for me to select 'Object in' or 'New sheet'. When I select new sheet I then get a new worksheet with a blank gray screen with no chart.

Please help!!!