How to label axis in excel 2020

How to label axis in excel 2020. Choose the desired diagonal direction (e. The Format Axis pane appears. Select the 3D Column Chart from there. Figure 3 – How to label axes in Excel. I found the solution easily on the web. A chart with an adjusted scale will appear as follows. Once you have accessed the Chart Elements menu, scroll down and look for the Axes option. Once you change the title for both axes, the user will now better understand the graph. To create multi-line axis labels, simply add a line break character (ALT + Enter) in the label text where you want to start a new line. For example, Visitors. I see no such options in Excel 2016. Uniform axis range for all rows or columns. Click the Format Axis option. Mar 10, 2020 · In the Horizontal (Category) Axis Labels box, click Edit. You can then select the desired angle to Sep 10, 2018 · 12. If you specify a value for the axis interval, you may experience unknowable label behavior, depending on the number of categories on the category axis. This can be done by clicking and dragging the cells that contain the data. In our chart, the Independent variable (Sales) is in the X axis and the Dependent variable (Profit) is in the Y axis. Check whether the "Hide the first and last labels along this axis" option is selected. Jun 7, 2012 · If you want to move the X Axis labels to the "Low" position, here is the code in VBA which might help: chart. Insert a chart: Go to the "Insert" tab and select the type of chart you want to create. B. Hi Surveza, Right Click on the Axis and choose Format Axis. Locating the Layout tab in the toolbar. 3, If you would only like to add a title/label for one axis (horizontal or vertical), click the right arrow beside ‘Axis Titles’ and select which axis you would like to add a title/label. Then find the Alignment area (depends on your version) Then Change Text Direction to Rotate All Text 270 degrees. In the Format Axis pane in the right, click the Size & Properties button, click the Text direction box, and specify one direction from the drop down list. You can easily change the X-axis values or la To add a secondary axis label in excel, follow these steps: Select the data: First, select the data that you want to include in the chart. Then, check the tickbox for ‘Axis Titles’. Click on it to reveal the options for both the horizontal and vertical axes. For the axis that you want to change, make sure that the axis labels show. Jan 17, 2023 · Step 3: Rotate Axis Labels. Click Add Chart Element, click Axes, and then click More Axis Options. Modify your new series from step 2 using the data columns from step 1. The waterfall chart will pop into your spreadsheet. Obviously, it is not true that "the cell is displayed exactly as entered. We will go to Chart Design and select Add Chart Element. Click on the Chart Elements button: This button appears when you hover over the upper-right corner of the chart. Access the axis options: Within the Chart Tools menu, click on the "Layout" tab. Select “Add Chart Element”: Within the Design tab, click on “Add Chart Element” to reveal a dropdown menu. Data Label Customization. Excel changes the tools that appear just below the link. After selecting your chart type, Excel will automatically produce a basic chart based on your data By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. In the Format Axis panel that appears, click the icon called Size & Properties and type -45 in the box titled Custom angle: The x-axis labels will be rotated at a 45 degree angle to make Dec 21, 2023 · Adjust Axis Scale. In the drop-down menu, we will click on Axis Titles, and subsequently, select Primary Horizontal. Step 2: Click on the "Chart Elements" button (the plus sign icon) that appears on the top-right corner of the chart when you hover over it. 4. Select the drop-down arrow and choose Line. Explain the importance of clear and readable x-axis labels for data analysis Click on the chart: Once the chart is selected, click on the specific chart where you want to label the X-axis. In the Format Axis pane, do any of the With the axis selected, right click and go to “Format Axis”. Define what x-axis labels are. (Source: Excel Campus) You can also format axis labels by changing font size, color, and alignment. To customize the font and format of your axis labels, click on the axis you want to edit and select ‘Format Axis’ from the ‘Format’ tab. 0, "B" into the Format Code box and then click add. I have been trying to look for solution in specifying interval between labels on the x-axis. Type in your Title Name . X-axis) and right-click on it. Step-by-step guide to adding labels to the x-axis. In the Tick Marks section, set the Major tick mark type and Minor tick mark type as desired. Select Secondary Axis for the data series you want to show. Select the chart. Move your cursor to Data Labels and choose a position in the pop-out menu. In the Axis label range box, enter the labels you want to use, separated by commas. Add axis titles: Navigate to the Chart Tools tabs and click on the "Layout" tab. Step 3: In the Format Axis pane, go to the "Labels" section. Go to the Chart Tools > Design tab. After setting the axis interval, all automatic labels will be disabled. Typing in the axis label is extremely time consuming. Provide step-by-step instructions on adding axis titles in Excel 2016. Step 3: Click on "Axis Titles" and choose either "Primary Horizontal Axis Title" or "Primary Vertical Axis Title". e. Right-click the chart title to format it with options like Fill or Outline. Jun 23, 2023 · Click on the chart elements button to display a list of options. In previous versions of Excel, the axis labels would automatically correspond to the column header. Make sure that the vertical axis crosses at category number 1. Oct 22, 2020 · 1. Type in the text for your axis label and format to your liking using the formatting options. Click Close to apply the changes to your chart. Nov 13, 2015 · In older versions, I could right click, choose "Format axis", then change the alignment of the label. ----- Excel allows users to customize the display of numerical data on the x-axis through custom number formats. Next, go to the Chart Tools section at the top of the Excel window. Axis Titles. Axis Labels Provide Clarity. Then, right-click on it. To get the labels back, go to the Format Axis task pane, and under Labels, Interval between Labels, select Specify Interval Unit, and enter 1. Apply Select Data Feature to Swap Axis. Go to the Insert tab on the ribbon. Click the + button on the right side of the chart, click the arrow next to Axis Titles and then click the check box next to Primary Vertical. For a pie chart, you'll see options like center, inside end, outside end, best fit, and data callout. In the Format Axis window that pops up, make sure that the icon on the far-right is selected (it looks like a bar graph with 3 bars). Move the mouse until you find one of your "Axis Labels" data points on the chart just outside (to the left) of the graph area, and right click. To customize data labels, click on a data point to select it. Select the range of cells A1:L5. Double Click on your Axis; Select Charts & Axis Titles . You can get the graph to look like this with a bit of work: 1 - Custom number format. Unfortunately, this hides information from us. X-axis labels in Excel refer to the labels that are displayed along the horizontal axis of a chart or graph. To create a custom number format for axis labels, first select the axis labels you want to format. Select Design > Change Chart Type. Click on the default axis title and type in your desired text. Choose the series for the y-axis. " In the Format Axis pane, click on "Fill & Line" and choose "Line. So your new X values should be your label points, and your Y values should be 0. 1. In the Format Axis pane, click on "Fill & Line" and choose the color you want for the labels under "Fill. In this step, we will rotate the axis labels to make them easier to read. Right click at the axis you want to rotate its labels, select Format Axis from the context menu. Rotate the labels: In the Format Axis pane, navigate to the 'Text Direction' option under the 'Labels' section. Click on Format Axis. Add a chart title. . Nov 20, 2022 · Select your pie chart and go to the Chart Design tab that displays. Click OK. In the Current Selection group, select Vertical (Value) Axis, or Horizontal (Category) Axis. Then, click on "Axis Titles" and select "Primary Vertical Axis Title" to access the options for the y axis label. Click on the " + " icon to access the Chart Elements menu. Select Combo > Cluster Column - Line on Secondary Axis. First of all, select the Y-axis, then right-click on the chart. The Primary axis is scaled from 0 to 10, and the Secondary axis from 0 to 200. TickLabelPosition = xlLow And the constants are defined as: Const xlCategory = 1 Const xlLow = -4134 (&HFFFFEFDA) If you want to move the whole X Axis (labels and ticks), here the VBA code for that: Click anywhere in the chart. Click + 4. How do I change the X axis values in Excel 2020? How to Change X Axis Values in Excel. Click the graph. Click the ‘+’ icon: This option opens up a menu where the axes, chart titles, and gridlines will be enabled as default. Jan 26, 2017 · Add a data series to your chart, then change the series chart type to XY/Scatter. The first step in labeling charts in Excel is to create the chart. Once the chart is inserted, click on it to activate the "Chart Tools" menu. youtube. Figure 2 – Adding Excel axis labels. If you only want to add either horizontal axis (x-axis) labels or vertical axis (y-axis) labels, do this: Click the chart, then click the “+” sign and hover over “Axis Titles”. Click an "Axis Title" text box. If you don't want to change the text of the Sep 9, 2023 · Right-click the axis labels whose angle you want to adjust. Excel displays a Context menu. A. Step 2: Right-click on the selected axis labels and choose "Format Axis" from the context menu. 14. Step 5: Format the axis label font, size, and color if necessary. Step-by-step guide on how to add axis labels to a chart in Excel. Select the + sign to the top-right of the chart. https://www. If your axis labels are particularly long, you may want to consider using multi-line labels. Click Edit on the Horizontal (Category) Axis Labels. First, open Excel and navigate to the worksheet containing the chart you want to label. In the “Format axis labels” dialog box, select the label options you want to change. " Manually typing in the x-axis labels did not work, either. Step 1: Select the axis labels on the chart by clicking on them. Step 1: Select the chart in which you want to customize the x-axis labels. To adjust Axis Scale, follow these steps. Aug 10, 2020 · According to your description, I did some tests on my side on different versions of Excel, I got the same results, but if I created some other charts such as Column Chart, the option to change the "Text direction" is available, in the Histogram Chart, not only for the Data Labels, but Axis is also not available to change the text direction. If you want to change the values on the Y-axis, you can follow the steps below. But I have no formatting options listed under Axis Options - nothing there. Now all of the labels are horizontal and visible, but they overlap. In the “Chart Tools” tab, go to the “Layout” tab and click on “Axis Titles”. First off, you have to click the chart and click the plus (+) icon on the upper-right side. Here’s a step-by-step guide to labeling the x and y axis in Excel for Mac. g. Click the Text Options link in the task pane. To change the scale of the x-axis, simply right click on any of the values on Mar 21, 2015 · 3. Repeat the process for the other axis. A text box will appear on the chart, allowing you to directly edit the x axis title. Click on it to open the Chart Elements menu. Step 2: Right-click on the selected labels and choose "Format Axis" from the menu. Oct 29, 2015 · Click anywhere within your Excel chart, then click the Chart Elements button and check the Axis Titles box. How do I set up Excel to automatically use the column headers as the axis label? Step 1: Right-click X-Axis, then click " Format Axis " in the dialog box; Step 2: In the " Format Axis " window, select " Rotate all text 270 " in the Text direction section; Step 3: The following is the chart after rotating. " Click on it to reveal more options, including "Primary Horizontal Axis", "Primary Vertical Axis". Select OK. Then, enter your custom number format code in the Type field. Add Axis Labels. Step 4: Enter the desired axis label text. This can help improve readability and prevent labels from overlapping. Launch Microsoft Excel and open the spreadsheet that contains the graph the values of whose X axis you want to change. 5 B". Add axis titles: In the 'Labels' group, you will find options for adding axis titles. Step 4: In the dropdown menu, find "Axis Titles. " Here, you can edit the x-axis data range by clicking on "Edit" and selecting the range Mar 6, 2024 · By default, your Excel chart might not have any axis labels. In the chart, select the "Chart Title" box and type in a title. To change the label, you can change the text in the source data. Open the Add Chart Element drop-down menu in the Chart Layouts section of the ribbon. Sep 19, 2019 · And to prevent overlapping, Excel has decided to hide alternate labels. Dec 26, 2023 · Sometimes, we need to modify or change the range of data points in the Y-axis in an existing graph. Select either “Primary Horizontal Axis Title” or “Primary Vertical Axis Title” depending on which axis you want to label. May 16, 2023 · 1. Step 3. Edit the x-axis: In the "Chart Tools" menu, go to the "Design" tab and click on "Select Data. Then, in the Axis option, type 2500 in the Maximum box, and 500 in the Major box. Alternatively, you can select the axis label and go to the "Format" tab in the ribbon, then click on the "Format Selection" button. Go to the chart and right click its axis labels you will rotate, and select the Format Axis from the context menu. Oct 28, 2013 · Start by making a plain old column chart. Select the arrow next to Chart Title. Edit the label: Once the axis options are displayed, you can edit the y axis label by directly typing in the desired text. " You can then customize the border by changing the May 10, 2015 · 1. Type in the label you'd like the axis to have. This will open the Format Axis pane on the right-hand side of the Excel window. In the Edit Axis dialog box, select one of the following options: Automatic. To do this, click your Excel graph. , column, line, scatter, etc. With the chart selected, you’ll see two new tabs appear on the Excel ribbon – ‘Design’ and ‘Format. Note in the image above under “Axis Options”, you can see that “Horizontal axis crosses” is set to “Automatic”. Create a chart: After selecting the data, go to the "Insert" tab and click on the desired type of chart. Click on the chart to activate the chart tools. Enter a vertical axis title. However, you can customize the scale to better meet your needs. I create a lot of charts in Excel. Dec 19, 2023 · Here, the X–axis represents the Employee Name, and the Y-axis represents the Salary. (i. ”. Enter the y-axis label: Check the box next to "Axis Title" to add a label to the y-axis. za/blog/date-axis-in-excel-chart-is-wrong/Images on websiteYou’ve built your chart, it all makes sense and suddenly you look a This will display the "Chart Tools" tab at the top of the Excel window. Step 3: In the Format Axis pane, navigate to the "Axis Options" tab. Show how to customize x-axis labels using specific examples. Aug 9, 2023 · Step 3: Within the "Chart Tool" tab, locate the "Add Chart Element" dropdown arrow. Feb 2, 2021 · 📊 In this video, you will learn how to change horizontal or x-axis Values in Excel charts (line or bar chart). Navigating to the chart in Excel. In the Format Axis pane, go to the Number section and select "Custom" from the Category list. Add a helper column to your data called Labels, set all of your values to =NA (), then set the values you want to label on your Jun 19, 2023 · Creating Multi-Line Axis Labels in Excel Charts. In some chart types, data labels can be used as axis labels. Dec 19, 2023 · Using this dataset, we create a chart to swap the axis in Excel. Selecting the desired axis to label. Step 1: Select the x-axis labels that you want to customize. So, the first step is enabling the axis titles. Close the dialog, then you can see the axis labels are Adjusting the Position of the Axis Labels. Click the Insert tab on the ribbon and choose the chart type you want to create. 500 million will show as 0. Figure 4 – How to add excel horizontal axis Click the Format tab. First, select the Y-axis on the chart. Click on the "Chart Elements" button (the green + icon) on the upper-right corner of the chart. This will show three options on the top right of the chart. Select the Axis Titles checkbox and click on the type of axis title you want to add. Oct 21, 2020 · 1 answer. Format the Secondary series so it is plotted on the Secondary Axis. , "Rotate all text 270°"). If you want to shorten your labels, click on Number and insert 0. Select "Axis Titles" from the dropdown menu, and then choose "Primary Horizontal" from the sub-menu. Mar 4, 2024 · You can use the VBA code below to add axis labels automatically to your charts and graphs. Aug 20, 2018 · I am following this steps to display date on the horizontal axis of a chart: Click the chart, and then click the Chart Design tab. 6. Oct 22, 2020 · From https://www. Jul 14, 2020 · Here are the two columns I plotted, with a pop-up Format Cells window showing the X column is defined as text. 3. Note that this will work only on the top level if you are utilizing the "Multi-Level Category Labels" feature of the chart. Click on the Column Chart button in the Charts Group. Double-click the axis that you want to edit. If you want to add more decimal places, just add more zeroes. In the Format Axis dialog, click Alignment tab and go to the Text Layout section to select the direction you need from the list box of Text direction. Click on the Axis Title you want to Change (Horizontal or Vertical Axis) 4. Step 2: Click on the “Chart Elements” button (‘+’ symbol) that appears next to the graph. Choose to display the x-axis on the chart. This inserts a 3D Column Chart in the current worksheet with default formatting. When the values that are plotted in the chart cover a very large range, you can also change the value axis to a Access the Format Axis pane: Right-click on the axis label you want to format and choose "Format Axis" from the context menu. Double click on the center axis line (between the blue and orange bars) to bring up the Format Axis control column. Oct 30, 2023 · Adding Axis Labels. Now, you might notice that the starting and ending totals don't match with the numbers on the vertical axis and aren't colored as Total per the legend. Click on it and press enter. To do so, double click any of the values on the x-axis. Click the Textbox tool. Within the "Chart Tools" tab, click on the "Layout" tab. May 21, 2019 · Answer. if you have a grouped axis) Steve=True. 5 B. The Select Data Source dialog box will appear on the window. In the Axis Labels dialog box, enter the new Axis label range separated with commas that you want to show as labels. In my case. Type the degree you want to rotate in the In the axis options tab, go to the “Axis labels” section and choose “More options”. Accessing the horizontal axis label options. The chart uses text from your source data for axis labels. This can help make the data more readable and easier to interpret. 2. See screenshot: 2. Selecting the chart to activate the chart tools. Right click on the axis numbers, select "format axis", go to the "number" section, and enter the following Custom format: "10^"# Click on 'Layout': Within the Chart Tools menu, click on the 'Layout' tab. In order to do so, follow the steps below. Axes(xlCategory). Don’t forget to include To select the y-axis in an Excel graph, follow these steps: Step 1: Click on the graph to select it. Next, we will click on the chart to turn on the Chart Design tab. A text box will appear on the chart where you can enter your desired label. com/channel/UCmV5uZQcAXUW7s4j7rM0POg?sub_confirmation=1How to label x and y axis in Excel Step 2: Click on the "Layout" tab in the Excel ribbon. Step 2: Right-click on the x-axis labels and choose "Format Axis" from the dropdown menu. ) Mar 11, 2024 · Step 4: Edit Axis Title Text. In Conclusion Hover your mouse over the "Axis Titles" option in the drop-down menu that appears. This thread is locked. In charts, axis labels are shown below the horizontal (also known as category) axis, next to the vertical (also known as value) axis, and, in a 3-D chart, next to the depth axis. A menu bar will appear. When modifying axis scale labels, remember to use clear and concise labels that accurately reflect the data. Click on the chart to select it, so the Chart Tools menu appears at the top of the window. Format your new series to taste. Check the Axis Titles box: In the Chart Elements menu, check the Jan 29, 2024 · To label an axis, click on the axis to select it, then right-click and choose “Add Axis Label”. Then, right-click and choose "Format Axis" from the menu. To add a vertical axis title, execute the following steps. May 20, 2023 · Step 2: Add axis titles. Steps: Firstly, select the horizontal axis (i. This displays the Chart Tools, adding the Design and Format tabs. ’ Access the axis labels: In the "Format Axis" pane, navigate to the "Axis Options" tab, and then the "Labels" section. Enter the desired label in the provided text box. In the Format Axis pane, go to the Number tab and add the desired unit in the Format Code box. Open your Excel spreadsheet and select the chart you want to edit. Then, a list of options will appear. Click on 'Axis Titles' and select either 'Primary Horizontal Axis Title' or 'Primary Vertical Axis Title' depending on which May 20, 2023 · Step 4: Customize the Font and Format of Your Axis Labels . In this example, we can see that the x-axis ranges from 0 to 20 and the y-axis ranges from 0 to 30. Jan 24, 2022 · Go to the Insert tab and the Charts section of the ribbon. From the drop-down menu, select "Axis" and then "Secondary Horizontal" or "Secondary Vertical" depending on the type of axis you want to add. By default, Excel will choose a scale for the x-axis and y-axis that ranges roughly from the minimum to maximum values in each column. Go to the Design tab: Click on the “Design” tab at the top of the Excel window to access chart tools. Select Centered Overlay to lay the title over the chart, or More Options for additional choices. Change the text direction: In the Format Axis pane, go to the "Alignment" tab and find the "Text direction" option. On the Format tab, in the Current Selection group, click Format Selection. Once the chart is selected, click on the axis you want to label. Excel displays the Format Axis task pane at the right side of the screen. Just click on the axis on the chart -> then click on Format axis to the right -> Axis options -> Labels -> Under Interval between labels I should be able to specify interval units. Open the Format Axis pane: Right-click on the selected axis labels and choose "Format Axis" from the context menu. Make sure that the chart uses A2:A for the category axis labels: If that doesn't help, double-click the category (X) axis or any of its labels. Step 3: In the Charts group, select the type of graph you want to create (e. co. Click on Labels and change the Label Position to ‘Low. All your billions will show up as "1. This will activate the Chart Tools tabs on the Excel ribbon. Feb 6, 2017 · You'll need to do a fair bit of manual formatting work, as Excel doesn't have the number format you want. Here, we want to reverse the X-axis by using the Format Axis Feature. Click “Close” to save the changes. Step 5: Choose the axis you want to label. We need to adjust these scales so the Primary panel is in the bottom half of the chart, and the secondary panel in the top half. 5. Step 1: Select the chart in which you want to add x-axis labels. All assistance I've found says there should be an alignment option under Axis Options. Your selected data will now be added to the chart as a third axis. Click the Waterfall drop-down arrow and pick "Waterfall" as the chart type. Step 3: Check the box next to “Axis Titles” and select “Primary Vertical Axis Title. Format your horizontal axis to use 2007 as your Minimum and set Axis Labels to None. The quickest (and I think easiest) way to do this is: Chart your data as-is (I prefer a scatter/XY chart for this type of chart). Open an Excel document. This will input the format into the "Type" dropdown list. Jan 28, 2022 · Step 3: Change the Axis Scales. Under Axis Type, select Date axis. Simply click on the text box and start typing the new title. Axis titles VBA code. Click Format Selection and then click the Axis Options category. " To add borders to the labels, again select the x axis labels on your chart, then right-click and choose "Format Axis. ’ In the "Chart Tools" tab, click on the "Add Chart Element" button. Jan 28, 2024 · Select the axis labels, right-click, and choose Format Axis. Step 4: You can also custom to any other angle in the Alignment section. Here are the steps to select the y-axis: Click on the chart to activate it. Entering the label for the x-axis. Apr 2, 2014 · 6. May 20, 2023 · Step 1: Create a chart in Excel. Automatically bases the axis range on the data used in the view. Before you can add axis titles, you need to select the chart that you want to edit. See screenshot: 3. This will display options for customizing the chart layout. Click OK in the Axis Labels box. See screen shot below: Select the chart by clicking on it once. Step 1: Open your Excel spreadsheet and select the data you want to include in the graph. The Select Data Series pop-up box should look like this. On the Format tab, in the Current Selection group, click the arrow in the box at the top, and then click Horizontal (Category) Axis. Click Axis Titles 5. In the "Labels" group, click on "Axis Titles" and select "Primary When creating a chart in Excel, it is important to select the appropriate x and y axis to accurately represent your data. Select a chart to open Chart Tools. Select "Primary Horizontal Axis Title" to edit the x axis title. Mar 11, 2020 · Automatic Axis Titles. To begin, select the data you want to include in your chart. We will convert the X axis into the Dependent variable (Profit) and the Y axis into the Independent variable (Sales). Find below the code and how to implement it in Excel: Developer tab Visual Basic button. And your graph should look like this: 13. Right-click on your chart > Select Data > Add a new series > call it "Axis Labels", and add the series X and Y values from your version of the above table. Understanding X-axis labels in Excel. This horizontal axis is Dec 7, 2021 · Create a waterfall (aka bridge) chart on any version of Excel and categorize the steps into meaningful categories in the axis. After completing these steps, your chart will have clearly labeled axes that make your data presentation more effective and Mar 5, 2022 · To add a 3D Column Chart in Excel, follow the steps mentioned:-. You can also right-click (control-click on Mac) the axis, and then select Edit Axis. If you want to display the title only for one axis, either horizontal or vertical, click the arrow next to Axis Titles and clear one of the boxes: Click the axis title box on the chart, and type the text. You can format the text using the ‘Home’ tab on the Excel ribbon, changing font size, style, and color to suit your chart. Move your cursor over it to reveal more options. On your worksheet, click the Developer tab and select Visual Basic inside the Code commands block. auditexcel. Select "Select Data". Access the Format Axis pane: Right-click on the horizontal axis and choose 'Format Axis' from the context menu. Select the chart: Click on the chart to select it. Select the chart: Begin by clicking on the chart to select it. Select Format Axis from the list Dec 21, 2023 · Right-click on the axis label > choose the Select Data option from the context menu. These labels represent the categories or data points being measured in the chart. Next, click on the Select Data option from the context menu. Choose either “Primary Horizontal” to only have an x-axis title, or “Primary Vertical” to only have a y-axis title. ’ These tabs contain various options for customizing your chart, including the option to add axis labels. Step 2: Click on the "Insert" tab at the top of the Excel window. Step-by-step guide on how to insert x and y axis in a graph. Here, you can change the font, font size, color, and other formatting options to suit your preferences. Look for the "Axis Titles" button, which is located in the Labels group. And there was no "Categorical Axis" option under Select Data, only Value Axis. With the chart selected, go to the ‘Design’ tab and click on ‘Add Chart Element. yd nd yn yz fh oo qq hr un um