MS Excel Tip – Need a chart fast??

Sometimes going through the Chart Wizards seems to take forever. If you want to put a chart into your workbook very quickly, you can follow these two simple steps:
Select the table on which the chart is to be based.
Press F11.
That’s it! Excel inserts a new Chart worksheet before the current worksheet, and bases the chart on the data in your table and the default chart type you have set up. At this point you can perform whatever customization you desire on the chart and work with it as normal.

There will be times when you need to create an Excel chart and you don’t have the time to go through all of the steps when creating charts via the Chart Wizards.

There’s a simple and quick way to insert a chart into your workbook with just two steps:

Select the table on which the chart is to be based.

And press F11.

Easy? Yes! Excel will insert a new Chart worksheet before the current worksheet, and bases the chart on the data in your table and the default chart type you have set up.

Once this is done, you can complete any customization you need.

You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.

Powered by WordPress | AT&T Cell Phones for Sale at iFreeCellPhones.com | Thanks to PalmPreBlog.com, MMORPGs and Online Shopping