How to create a graph chart in Excel

By
 Hello everyone and welcome to another tutorial where this time I'm going to show you a simple step by step tutorial on how to create a graph in Excel in just under a minute. Firstly, before you start open Excel under a blank workbook and for a more simplified execution of this task as an example I'm using here city names and their population, that's what our graph is going to consist of. 

     1. First step what you're going to do is on the A1 to D1 column write the city names that you would want to use. After you've done that, on the A2 to D2 column write the population of those cities as in my example.




    2. Step two, (make sure you've selected all the columns from A1 to D2) go to Insert and select the desired graph that you would want to use. In my case it's Insert statistic chart. As you can see from the picture below, on the red rectangle you can select different graphs and charts to choose from.




   3. Once, you've selected the desired graph or chart in my case i'ts the statistic chart, it should appear as in the picture below, now if you're not happy with the design of the chart, you can easily change it as shows on the picture below (red pointer). Simply scroll over them and choose your favorite one.



   4. Now that the chart is created, you can see from the picture above that the chart is formatted by default and it doesn't fulfill our visual requirements on what the final process should look like. Therefore, with a quick and easy formatting of the chart should do the trick. Simply, click on the plus shaped icon right next to the chart and a small window under the name chart elements will pop out. Once that does, check the box under the name Data Labels. Once you've checked the box, under the Data Labels a new small window will appear where you can select where the visual statistic would want to appear. In my case, I've clicked on Outside End. Here's the example in the picture below. 




   5. Next, if you click on the brush shaped icon right next to the chart a window will appear under the category Styles where you can select various designs and styles of your graph or chart. Click the one you like and the chart will automatically change it's style. For a simplified tutorial I've kept the style of the chart unchanged. 




   6. Next to the Style category, you're going to find the color category where you can scroll to you favorite colors that can suit your graph or chart. Simply select the colors that best suit your graph and the changes will be made automatically. Again, for a much simplified tutorial I've kept the colors unchanged.



   7. Once you've finished with your graph or chart, but on the last minute you change your mind regarding the graph or chart type you can easily do that with just a few clicks. What you have to do is right click on the chart and a small window will appear where you have to click on the Change Chart Type. 



    8. When you click on the Change Chart Type this window will appear under the category All Charts. Once you finally decided what to type of graph or chart to use click the OK button and everything will be changed to your preferences. As you can see on the picture below, I went with the Line chart with a 3-D line preset.




   9. Here is the 3-D Line chart that I've changed. Bare in mind that you have to redo the formatting for the visual categories under Chart Elements. Just click the categories that will most suit you under Chart Elements.  




Here's also a video tutorial for you to see.



Comments

Post a Comment

Popular posts from this blog

How to create a barcode using Excel

By
Image
Hello everyone and welcome to another tutorial where we are using Excel to create or generate a barcode using very simple few steps. Before starting with this tutorial make sure you have downloaded a barcode font where we're going to use it in the next steps. Finding a barcode font is very easy, just google the font and you'll be able to download various barcode fonts.     1. First step, enlarge the A and B column so that the barcode would fit in. By doing so, in the A column select the number format as Text.     2. Next, under the A column, we have the serial number ID that will generate the barcode (you can also use letters instead of texts).    - Use the formula to generate the barcode: ="*"& A2 &"*"     3. After you've entered the barcode formula drag and drop so it can automatically generate the barcode for the rest of your serial number ID.     4. At this stage, select all the gen...
Read more

How to create a simple database in Excel

By
Image
In this step by step guide, I'm going to show you how to create a quick and simple database using Microsoft Excel. Even if you've just started using Excel for the very first time this tutorial doesn't require any intermediate skills, all you have to do is follow the logic behind the steps that will create this database function. For this database we're going to use the DSUM, DAVARAGE, DMAX and DMIN functions.      1. Step one, have an idea on what your database will consist of, in my example I have used a simple smartphone database. So, from cells A6 to F6  write down the categories on what your database will consist of and whats you did that make sure you highlight the categories with Bold and fill the cells below with the required information. As you can see from the example below I have filled the necessary information to each category.   - Once you're finished with the first step, note that as seen in the example below in the highlighted cells...
Read more

How to create an actual cell vs target graph in Excel

By
Image
Hello everyone and welcome to another tutorial where this time we're going to see how you can make a very quick and simple actual cell vs target graph in Microsoft Excel in just a few easy steps.      1.   First step, fill in the cells as seen on the picture bellow and write down the benchmark of units sold on the target or goal cell. Now that we have the benchmark of 100 units sold as our primary goal, head over to the actual cell and write down a random or in your case the actual number of units sold. Once you've done that on the graph cell type =D5  as seen on the picture where we will use the formula to show the graph in the next step.     2. Step two, once you click enter you will notice on the graph bar the progress is 50 units of the 100 target units sold. To add the graph go to Conditional formatting > New rule     3. When the New Formatting Rule window opens head over to Format Style and set it ...
Read more