Super fast way to create a new chart in Excel

fast way to create a new chart in Excel

Are you familiar with this scenario? You just finished your report and are under pressure due to lack of time. Now you need a good chart to visualize your result. Surely you have created charts in Excel in the past, but now you don’t remember the exact steps.

Yes, of course, you can use the chart wizard to create your chart, but there are some occasions when it takes too long to create a chart through the wizard. So if you feel the need for speed, then this trick is for you.

I have put together some easy steps to create a quick chart for you in Excel. It does not require much time and can be used for all types of different data. Graph, line or pie chart, the choice is yours.

fast way to create a new chart in Excel

So in order to create your Excel chart in just a second, flatten these steps.

Method-1: Keyboard Shortcut Se Excel Me Chart Banaye

Create a chart by simply pressing a key from the keyboard

The first trick is to create a chart in a stand alone worksheet in Excel. A stand alone is a worksheet that creates a new sheet in front of your current worksheet, which contains the chart and is known as a chart sheet. This sheet is named Chart1 by default.

First, create a data table in an Excel worksheet, and then highlight or select the data range on which you want to create the chart.

Press the F11 key from the keyboard

Your chart will be created in a new worksheet within the Excel workbook.

There is a faster way to create charts in Excel

Now you can customize your chart in any way and work on it as you normally would.

Although it is good for full page printing, it is not the correct use of a dashboard and will not be thought of as a good dashboard design. Usually most dashboard designers embed graphs into the same Excel worksheet. That is what you will see next.

How to Quickly Create an Embedded Chart

How to create an embedded chart

Do you want to create an embedded chart? So follow the quick steps given below:

Highlight the chart range to create an embedded chart in Excel, then…

Press Alt + F1

Your chart will be created in the current Excel worksheet.

Is it cool

Bang !! is that all. With Excel a quick graph of your data will be created in the current Excel worksheet.

I think this quick quick method can be really useful if I want a different view of the data for quick comparison to preview how I can see a graph before I start working on it.

This method of charting is not good in any way, but you get the chart in the blink of an eye.

Method-2: Quick Analysis Charts Se Excel Me Chart Banaye

Note that this feature is only available for Office 2010 and later.

First of all you need to select the data.

Then click on the small Quick Analysis button below this data.

Select Charts and then hover over the various recommended charts.

Click on what you feel is right.

So the comments below let me know what you think about this super fast method.

Read this too:-

• What is PC and full form of PC

• What is UPS and full form of UPS

• Convert a Row to a Column in Excel

• Free Online Typing-part-18