In cell vs target chart in Excel

By


Hello everyone and welcome to another tutorial where this time we're going to follow through our last exercise where we tweak some things and finish it off with a chart.


   1 Step one, select the columns from A to T (or to any column you feel it's far enough), Right Click > Column width and set it to 17. 





   2.  Step two, fill in the cells with the order you see in the picture down bellow.





   3.  Step three, under Conditional Formatting format the new rule and under Value > Maximum make sure you select the cell right beside Goal. 

 You probably know by now how you're supposed to format your new rule. If you're new to this tutorial then please visit our last exercise: https://letslearnitnow.blogspot.com/2020/04/how-to-create-actual-cell-vs-target.html





   4. After you've successfully created the new rule, please do edit and format the table so it will have that clean look. 




   5.  To create a bar chart please select all the cells and then go to Insert > Insert chart. When you click on the chart you will notice that the chart is not formatted with all of the necessary information. To do that, click on the + (chart elements) and a small window is going to appear and that is where you will find all the important data and information regarding your table. Play around the chart elements until you find your most important data to be displayed in your chart. 


   6. To further format your chart, double click on each bar where the Format Data Point side window will appear and there you're going to find a handful of categories where you can customize your chart. I've only added a shadow preset and changed the colors of each bar, but you could play around and add more customization to your chart.    





   7.  And there you go, here you have the January report in both graph bar and chart display. To remove the guidelines in Excel, go to View  and click on the Gridlines. By doing that, the gridlines will disappear. 




   8. If you want to add more tables and charts for each of the months, simply copy and paste the table where you want it and change the numbers for that particular month and then insert the chart.  Your spreadsheet should look similar to the picture below.

   Note: Instead of having all the months in one spreadsheet, you can also create a new spreadsheet for each month.   
Here's also the video showcase...



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 generated barcode nu
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 as Data Bar and click on the Show Bar Ico
Read more

How to create a student result sheet in Excel

By
Image
In this tutorial I'm going to show you how to use the IF function (logical test) with the True or False value. Also, how to use symbols in excel.     1. For us to use the IF function and Tick symbols, firstly we have to create a basic student data sheet where you can type the necessary information such as: Student name, subject, score, status etc. The first step for you to do is write down a simple student sheet with the as seen on the picture below.      2. Step two, on the Student column select the cells from A2 to A10 , right click > format cells click on the merge cells box, then set the orientation to 90 degrees and click OK.    3. Once you've merged the cells, write down the name of your student and make sure to align your content and text to center and middle as seen on the picture below. Also, make sure you change your font size to your liking as well.       4. Next step, write down the scores of your student on each of t
Read more