Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 49 - CodePilot V5.0 C7
P. 49

    CREATING A CHART
     CONDITIONAL FORMATTING
                     Creating a chart in Excel is a simple process. To create a chart, follow the given steps:

     Conditional  Formatting  allows you  to  apply  formatting  (such  as  colours  or  styles)  to  cells
     automatically based on their values. This makes it easier to highlight important data and trends   2    Click on the Insert tab.  3    Click on the Insert Column or Bar Chart option.
     for quick analysis.
     To apply Conditional Formatting, follow the given steps:
                                                                                              4    Select the chart you want
     2    Click on the Conditional Formatting option.                                         to add in your worksheet.
                       1    Select the range of
                       data you want to plot.

     3    Hover your mouse pointer over Highlight
     Cells Rules and select Less Than.

     1    Select the range of cells you want to format.
                     Excel  will automatically generate  the  chart  on your  worksheet.  You  can  then  customise  it  by
                     clicking on the chart and using the Chart Tools to modify titles, labels and styles as needed.

     4    Enter the value and   COMPONENTS OF A CHART
     select the formatting style.
                     A chart is made up of several key components:
                                                                                                       QR QUEST
                         Chart  Area: The entire  space  that  holds the chart,
     5    Click OK to apply the formatting.
                        including all elements.                                                     Visit the given link
                                                                                           to learn more about how to
                         Chart  Title: A title  that  describes  the chart, making  it           modify charts:
                        easier to understand the data.                                       https://www.youtube.com/
                                                                                              watch?v=RFbhD03x0Ac
     The cells with values less than the specified number will be highlighted with the selected format.    X-axis: The horizontal axis of the chart, also known as   Answer the given questions:
                        the category axis.                                              1.   How can you  change the
     Ask                                                                                   chart title in Excel?
     AGENT               Y-axis: The vertical axis of the chart, also known as the
     OrangeAI                                                                           2.   Name  two  chart elements
     Prepare a worksheet that applies Excel formulas and functions to solve practical problems.  value axis.  you  can modify  in Excel as
                         Plot Area: The region where the data series are plotted,          mentioned in the video.
     Study
                        excluding labels and titles.
                         Data Series: The actual data that is plotted on the chart. A data series is represented by a

     CHARTS IN EXCEL    series of markers (bars, lines, etc.).
                         Data Labels: Labels that show the actual values of each data point on the chart.
     Charts are powerful tools that help you visually represent data, making it easier to analyse and     Gridlines: Lines that help viewers read the values of the chart more easily by dividing the plot

     communicate insights. They allow you to quickly identify trends, patterns and comparisons in   area into uniform sections.
     your data.

                                                                                                                      47
                                                                                                         Excel in Excel

| 44 45 46 47 48 49 50 51 52 53 54 |