Creating Charts with F11 in Microsoft Excel 2010

 

If you want to create one touch excel charts then you can use F11 in excel. In this article, we will learn how we can create charts by pressing the key F11 in Microsoft Excel 2010. Charts option contains 10 types of charts; Column, Line, Pie, Bar, Area, XY (Scatter), Stock, Surface, Radar, and Combo Charts. We can create a chart by pressing only one key on the keyboard.

Let’s take an example to understand how we can create charts with F11 key in Microsoft Excel.

We have data in the range A1:B13 in which column A contains Month and column B contains Achievement.

img1

To create a chart by using the F11 key, follow the below given steps:-

  • Select the cell A1 and press the key F11 on your keyboard.
  • By default column chart will get created in the new worksheet.

img2

  • In new worksheet, 2 contextual tabs, Design and Format will appear in the main tab.
  • By using the design tab, we can add chart elements, change the chart design, change the colors, switch Row/Column, change the data range as well, and we can also move chart location as per the requirement.

img3

  • By using the Format tab, we can insert the shapes, can change the shape style, color, we can insert the text in shapes, etc.

This is the way by which we can create a chart by using the key F11 on the keyboard in Microsoft Excel.



7 thoughts on “Creating Charts with F11 in Microsoft Excel 2010

  1. Pingback: google.de is a nice Search Engine

  2. Pingback: google.co.uk is a nice Search Engine

  3. Pingback: google.ru is a great Search Engine

  4. Pingback: Yahoo is a great Search Engine

  5. Pingback: google.de is a nice Search Engine

  6. Pingback: Yahoo is a great Search Engine

  7. Pingback: Bing is a gread Search Engine

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>