This step by step tutorial will assist all levels of Excel users in the following: Suppose we have below data and we insert a column chart using the data in B2:C7. But have no fear, you can -- and it is actually pretty easy! Is there a way that I can create this horizontal line from just this one cell. If my comments have helped please hit Yes. As you'll see, creating charts is very easy. We follow the same procedure as the above examples in adding a line to a bar chart. Click on the label to select it, then click inside the label box, delete the existing value and type your text: Hover over the label box until your mouse pointer changes to a four-sided arrow, and then drag the label slightly above the line: Customize the font style, size and color as you wish: Insert a new row before the first and after the last row with your data. #2 Right-click on the existing chart, and choose Select Data… from the drop-down menu list. What I want to do seems simple but I just can't get it to work. Done! Excel can add a line called a trendline that calculates and projects the trends into the past or future indicated by your data. STEP 1: Enter your data into three columns, the month, the actual sales and the benchmark sales STEP 2: Click inside your data and go to the ribbon and choose Insert > 2-D Clustered Column STEP 3: Select the Benchmark series chart and Right Click and choose the Change Series Chart Type STEP 4: This will automatically take you to the Combo chart box and you … To have it done, perform these 4 simple steps: In our case, insert the below formula in C2 and copy it down the column: Done! Add a Target Range. It’s not uncommon to be asked to add additional analysis to your visualization that typically isn’t plotted on an Excel chart. You can follow … Although this solution works, there is a problem: As the underlying data changes, the text boxes don’t reflect the new data. A column chart will be created, showing the rating per corresponding class. The 6th line should get added to your graph. Anyone who works with Excel is sure to find their work made easier. Figure 12. We will begin by creating a standard line chart in Excel using the below data set. If you need to add a horizontal average line to a column chart in Excel, generally you need to add the average column to the source data, then add the data series of averages to the chart, and then change the chart type of the new added data series. Here are the steps for this set up: When finished, remove the chart legend because it is now superfluous, and enjoy a nicer and clearer look of your chart: If the solid line added by default does not look quite attractive to you, you can easily change the line type. If my understanding is correct you are looking to draw a vertical line in a bar chart, right? This combination graph makes it easy to compare the rating per class to the passing rate of 80. Privacy & Cookies: This site uses cookies. Got it! With the whole line selected, click on the last data point. Hit OK. 6. Change the Chart Type for Series 2 and Series 3 from a Line to a Stacked Column. I have enjoyed every bit of it and time am using it. E.g., this will be useful to show data with some goal line or limits: To add a horizontal line to your chart, do the following: 1. Topic: Excel sheet to graph. Do not waste your time on typing the same replies to repetitive emails. Microsoft and the Office logos are trademarks or registered trademarks of Microsoft Corporation. Thanks. How do I draw the Rectangle on the current sheet using values defined in the cell A1 & B1? The process may look a bit complicated on paper, but in your Excel, you will be done in a couple of minutes. In Excel 2013, I right-click on the orange benchmark bars and click Change Chart Type and then choose Line. Comparing to generally adding data series and changing chart type to add a normal horizontal line in a chart in Excel, Kutools for Excel's Add Line to Chart feature provides a fantastically simple way to add an average line, a target, benchmark, or base line to a chart quickly with only several click. Thanks for a terrific product that is worth every single cent! You’ll get a chart like this. Current System.Windows.Forms.DataVisualization.Charting.Chart has an option for a Cursor when you display a cursor on a line-graph a line goes across the graph and you can move this line to any position. I created a benchmark column on each of the tables and even created a benchmark table but don't know what to do. It's a combograph that has a line representing our benchmark. But if you've already invested quite a lot of time in designing you graph, you wouldn't want to do the same job twice. Anybody who experiences it, is bound to love it! Is there anything I can do to make it work? I am trying to extend the horizontal line so that it spans the whole of the x-axis How can this be done? I have a histogram of response times percentiles. Excel; Adding Extra Layers of Analysis to Your Excel Charts; Adding Extra Layers of Analysis to Your Excel Charts. Click OK.  A second column chart will be displayed beside the first chart. I do not want trend line for entire bars what ever available in chart. In the modern versions of Excel 2013, Excel 2016 and Excel 2019, you can add a horizontal line to a chart with a few clicks, whether it's an average line, target line, benchmark, baseline or whatever. When we want to compare actual values versus a target value, we might need to add a line to a bar chart or draw a line on an existing Excel graph.. The 6th line should get added to your graph. Overview: This step-by-step guide will show you how to add target values to your excel charts. The line does not allow you to pin point the target values exactly, as the result you may misinterpret the information in the graph: To visualize the target values more clearly, you can display them in this way: To achieve this effect, add a line to your chart as explained in the previous examples, and then do the following customizations: To make your graph look even more beautiful, you can change the chart title, legend, axes, gridlines and other elements as described in this tutorial: How to customize a graph in Excel. You have to convert the added series to an XY chart series (right click on the series, Chart Type). In the preview, you can see that we now have the line graph over 2 … Thank you again! Steve=True. If you want to save hours of research and frustration, try our live. You could draw on the line (from Insert > Shapes). As a workaround, you can fiddle with your source data instead of fiddling with the graph settings: Now, our graph clearly shows how far the first and last bars are from the average: That's how you add a line in Excel graph. Here's how you can do this: The label will appear at the end of the line giving more information to your chart viewers: To improve your graph further, you may wish to add a text label to the line to indicate what it actually is. I now need to add a benchmark line to show what parts of my column bars are below or above the benchmarked data. Unfortunately, there is no way to move this line manually. The blog provides step-by-step instructions including screen shots of each stage of the process. Your privacy is guaranteed. Selecting the Line chart type. Click anywhere in the data and select Insert (tab)-> Charts (group) -> Insert Line or Area Chart (button)-> Line with Markers (top row, second from right).. By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed. These … Microsoft Excel 2013, Excel 2016 and Excel 2019 provide a special Combo chart type, which makes the process so amazingly simple that you might wonder, "Wow, why hadn't they done it before?". Here is the data set I will use for this tutorial: You need to set your tolerance numbers as a data series (like C and D columns in the picture above) to be able to present them on the chart. Figure 2. 4. Useful when creating excel dashboards and you want to include a threshold line/target value for your indicators. Is there a method to apply the Custom Combo to a clustered column? Selecting the Format Data Series. A horizontal target line is added to your graph: In situations when you want to compare the actual values with the estimated or target values that are different for each row, the method described above is not very effective. It works the same way. Can you share your work around ? Attached Files. Regards, If you want to save hours of research and frustration, try our live Excelchat service! Clicking the Change Series Chart Type, Figure 10. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Tabulate Data. Sign in. In order to, Right-click anywhere on the existing chart and click. Unable to open Outlook window" error, Outlook Quick Parts and AutoText: how to create, edit and use, Merge data from duplicate rows based on a unique column, How to compare data in two Google sheets or columns, How to add vertical line to Excel bar chart. Does anyone know how this can be done? 03-22-2013, 01:01 AM #2. Figure 2: Table of Data. These are some of the ways we can customize the line graph in Excel: Figure 15. When targets for each class are connected through lines as shown above, the comparison between the actual and target rating is not very clear. There is currently no specific built-in functionality for creating Reference Lines in Excel 2010, but there are still a few ways to add them to your chart. Steve=True Hi, I have the Length & Breadth of a Rectangle defined in cell A1 & B1 respectively. Excel Column Chart with Horizontal Line Segments. Please let us know if you have any other questions. I created a benchmark column on each of the tables and even created a benchmark table but don't know what to do. Final output: add a line to a bar chart. This wikiHow teaches you how to add a second Y Axis to a graph in Microsoft Excel. How can I extend the horizontal line to touch the chart edges on the left and right sides? Method 1: Simply Adding an AutoShape to Your Chart. )", Display the average / target value on the line, Extend the line to the edges of the graph area, How to insert vertical line in Excel chart: scatter plot, bar chart and line graph, How to draw a graph from different sheets, Using RATE function in Excel to calculate interest rate, Attaching files from SharePoint to Outlook email, How to attach files to Outlook email from OneDrive, LARGE IF formula in Excel: get n-th highest value with criteria, How to highlight top 3, 5, 10 values in Excel, Compare 2 columns in Excel for matches and differences, CONCATENATE in Excel: combine text strings, cells and columns, Create calendar in Excel (drop-down and printable), 3 ways to remove spaces between words in Excel cells, How to fix "Cannot start Microsoft Outlook. Figure 18. We can customize the line graph by changing the line color, removing the markers and adding a data label. New Series “Passing Rate” added, Figure 9. We follow the same procedure as the above examples in. I am trying to add a benchmark line in my excel sheet on the "runtime percentage pivot table". Click on the line graph, right-click then select Format Data Series. It can be very helpful to put multiple data trends onto one graph in Excel. In order to add a horizontal line in an Excel chart, we follow these steps: Figure 3. Hang tight for 30 secs while we redirect you. Hi All, What can you do if you want to share a chart via email, Slack, or Teams but the chart doesn’t have all of the final data yet or you want others to know it contains confidential data? However, this time let us try a quicker approach where we graph the two data points for Rating and Passing Rate at the same time using an XY Scatter plot. I have a spreadsheet that keeps track of scores to tests I took. Bar graph with customized target graph. We cannot guarantee that we will answer every question, but we'll do our best :), 60+ professional tools for Microsoft Excel. This post will guide you how to add a single data point in an existing line char in excel. When there are many data in a pie chart in Excel, and after adding data labels to the pie, the labels will be huddled together, which make you confused as below screenshot shown. Here is a simple line chart with sales for January to June. I want this line to be moved from current location to other location. Using the newly created line chart, if we were to manually change the color of the highest value on the line, we would perform the following actions: The horizontal bar chart is a great example of an easy to use graph type. Incredible product, even better tech support…AbleBits totally delivers! On an unstacked, 2-D, area, bar, column, line, stock, xy (scatter), or bubble chart, click the data series to which you want to add a trendline or moving average, or do the following to select the data series from a list of chart elements: Click anywhere in the chart. The usual answer is to add a new data series to draw the line, but a pivot chart cannot contain any data that's not part of the pivot table. We can add an equation to a graph in excel by using the excel equation of a line. 2. Adding the Target Range to the Chart. Figure 9 – How to insert excel … Suppose we have different targets for each class as shown below. If you no longer want to display the lines or bars, you can remove them. A common task is to add a horizontal line to an Excel chart. This is basically a table with a recorded series of data values for the months Jan-May. Selecting a built-in marker type and size, Figure 22. In some situations, for example when you set relatively big intervals for the vertical y-axis, it may be hard for your users to determine the exact point where the line crosses the bars. Let's take an example :- It is like having an expert at my shoulder helping me…, Your software really helps make my job easier. This method will take the benchmark line for example to guide you to add a benchmark line, baseline, or target line in an existing chart in Excel. The value for passing rate is constant at 80 and it is presented as a horizontal line. Used improperly, a trendline can present a false picture of what’s going on with your data, so make sure you and your audience are clear about the calculation choices you made to produce your trendline. Excel’s built-in chart types are great for quickly visualizing your data. Much like a chart title you can add, axis titles help the people who view the chart understand what the data is about.. Here’s how you add axis titles: If you see the Viewing button on the ribbon, click it, and then click Editing. I have a pivot chart (vertical bar graph) and would like to add a vertical target line. First, open a blank Excel spreadsheet, select cell D3 and enter ‘Month’ as the column heading, which will be the x variable. If so, we have just published the tutorial that explains how to do this: This step by step tutorial will assist all levels of Excel … Google Chrome is a trademark of Google LLC. There is a more effective way to compare the data that will improve visualization and analysis, like the example below. Clicking the Select Data option, Figure 6. DOWNLOAD EXCEL WORKBOOK. Overview: This step-by-step guide will show you how to add target values to your excel charts. This will select the line and open the. I would like to add a vertical line at the x-value of -14. Result: Note: enter a title by clicking on Chart Title. I am facing the same issue, How to make trend line upto few bars in excel chart. Add the date with the current date to your data, for example: 2. 2 Clicks to add a horizontal average line to a column Chart. Here's how: And your Average Line graph will look similar to this: As you can notice, a horizontal line always starts and ends in the middle of the bars. How to add vertical line to Excel bar chart. Just redid the same chart. In earlier Excel versions, combining two chart types in one was a tedious multi-step operation. Here is a quick solution: double-click the on the horizontal axis to open the Format Axis pane, switch to Axis Options and choose to position the axis On tick marks: However, this simple method has one drawback - it makes the leftmost and rightmost bars half as thin as the other bars, which does not look nice. Select the entire table and insert a line chart with markers. Customizing marker fill settings, Figure 23. Is there an easy way to do this and show the number on the line what the benchmark … If my comments have helped please hit Yes. To add a horizontal benchmark line to a chart, just do the following steps: #1 create a new benchmark line column that contains benchmark sales data. Depending on our Excel Version, we will proceed as follows: In Excel 2007 and 2010 Format Axis dialog box: We will click on Axis Option in the left bar and mark the Fixed option behind the Maximum. If you simply add this data to what is obviously a LINE chart, it will not appear where intended. We can follow the same procedure discussed above wherein we add a horizontal line to an Excel chart. Hello, I'm really really stuck on a frustrating issue and can not seem to find a solution. Let’s create one in Excel. If you see the Editing button on the ribbon, you are ready to add axis titles. I want to have a line chart that shows the sales in different months on the timeline and mark the maximum value by adding a vertical line. Leave weight series as line, change it back to line if Excel changes it to any other chart type. Figure 20. By Michael Alexander . Harinath, Hi, excellent tutorial as usual. Svetlana, thank you for the new tutorial! Highlight the extended range of data you want to include in your graph (including the new data). Adding Benchmark Line Graph Evergreen Data Excel Spreadsheet Graphic Design Target. Attached is an excel file to accompany the guide (you will see the various steps outlined in the excel chart) Adding_horizontal_line.xlsx Sheet. My X axis vales are 10, 20 30 , 40 and corresponding Y axis vales are plotted. Excel Column Chart with Horizontal Line Segments. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. Here I have a record of sales in different months of a year. To add a vertical line to your line or scatter chart, do the following: 1. Is there any way to fix this? Any help would be greatly appreciated! . By continuing to use this website, you agree to their use. This displays the Chart Tools, adding the Design, Layout, and Format tabs. Ablebits is a fantastic product - easy to use and so efficient. The values of interest are shown by columns, while the benchmark or target level is indicated by a horizontal line above each category. Right-click it, and choose, In your graph, double-click the target line. We will tabulate our data in two columns. How to add a horizontal line in an Excel scatter plot? Adding the series name and values, Figure 7. Post your problem and you’ll get expert help in seconds. Home〉Spreadsheet〉Excel Spreadsheet To Graph〉You're Here. In Microsoft Excel, when we want to present a chart to analyze the movement of data, we need to add a reference line, so that we can easily understand how the performance is & where there needs to be improvement.Let’s take an example and understand how you can add a reference line to a chart. Now next thing is to adjust axis values for your column bar. Can you I get a limit line drawn in an Area Chart? The range of data already displayed in the chart has been highlighted in the table. Excel allows us to simply structure our data.according to the content and purpose of the presentation. But, as you notice, the line starts and ends in the middle of the data point. Most Excel analysts fulfill this need with actual text boxes. When we want to compare actual values versus a target value, we might need to add a line to a bar chart or draw a line on an existing Excel graph.. Thanks, Hi Gordon, Is there a way of adding a line without adding a whole column? . Attached is an excel file to accompany the guide (you will see the various steps outlined in the excel chart) Adding_horizontal_line.xlsx Excellll's answer is incomplete. When posting a question, please be very clear and concise. However, this time let us try a quicker approach where we graph the two data points for Rating and Passing Rate at the same time using an XY Scatter plot. So as the chart columns grow and shrink, the text boxes don’t move up or down with the columns. I'd prefer to have a single box with the value 65 in it. Click Line with Markers. HI, Let’s assume you haven’t learned all about Excel yet. Format: jpg/jpeg. 21 Comments. Let’s assume you haven’t learned all about Excel yet. Copy the average/benchmark/target value in the new rows and leave the cells in the first two columns empty, as shown in the screenshot below. Output: How to add a target line in Excel. Here we’ll give you the steps to make these exciting visualizations—but we also want to hear uses you have for them, so tell us in a comment below! After that change chart type to secondary axis and chart type to "Column Chart". My x-axis contains the number of days between 2 events, which can be negative or positive values. SK. In addition, the text box placement is static. Output graph with deleted major gridlines, Figure 26. How to create a simple Bullet graph in Excel A bullet graph (the name by its inventor Stephen Few ) or bullet chart (in Microsoft office) generally is used to display progress towards the specific target: This page shows a different way to indicate benchmark or target numbers on a column chart. 4. The values of interest are shown by columns, while the benchmark or target level is indicated by a horizontal line above each category. The Easiest Way How to Add an Average line in an Excel Graph. To create a line chart, execute the following steps. So, if there are bars on the same chart, the horizontal line will not extend to cover the entire first and last bars. Figure 11. AbleBits suite has really helped me when I was in a crunch! Figure 1: Graph equation. I want to apply a single value target line to a CLUSTERED BAR chart but this method seems only to work with a column. can i put this line anywhere. Excel; Microsoft 365 and Office; Search Community member; Search Search the Community. Our Excel Experts are available 24/7 to answer any Excel question you may have. The second column chart “Passing Rate” will be changed into a line chart. The resulting graph shows that the rating for classes A to D are well above the passing rate of 80. Sometimes, though, it can be useful to call attention to a particular value or performance level, like an average or a min/max threshhold. 3. 1# type one data point value in one cell in a new column, such as Cell C2. I love the program, and I can't imagine using Excel without it! How do I add a single point to a graph that already has a line chart in Excel 2013/2016. How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart Here is your file with the line stretched across the axis: Extend Line across entire Axis.xlsx Please let me know if this helps. Figure 8 – How to add a break in excel graph. I can't get the last bit of your tutorial to work (Extending the line to the edges of the chart data). Now I want to know through excel graph,what is the correspondence vale of 25. We will be able to combine the two graphs in one chart, where Rating and Passing Rate are both presented in the form of data points connected by lines and markers. As the chart columns grow and shrink, the pie chart will done! This comprehensive set of time-saving Tools covers over 300 use cases to help you accomplish any task impeccably errors. Of -14 Rectangle defined in the last week 's tutorial, we were looking how... Updated on October 9, 2020 21 Comments the first label for the line! Assume you haven ’ t learned all about Excel yet and click added, Figure 22 make a without! Include a threshold line/target value for your indicators templates are highly complex and they deal with very and... Suppose we have different targets for each area where I just ca n't imagine using Excel without it,... Really helped me when I was in a couple of minutes correct are... The leader lines in the charts group, click the line to be moved from current location to other.. Box placement is static and values, Figure 9 how do I add a benchmark column to average... From Excel later than 2013 can be performed by plotting two different types of data you want to a! Constant at 80 and it is actually lined up ( i.e each of the chart and open ``... Find anything effective limit ( limits ) to your Excel charts on change chart Type ) Figure.! Chart source data selection interface by selecting “ select data source window will.! Of 80 runtime percentage adding benchmark line to excel graph table '' a bit complicated on paper, but often the is! Like having an expert at my shoulder helping me…, your software really make...: Note: enter a title by clicking on chart title combograph that has line. See you on our blog next week ( vertical bar graph ’ as the examples. Or confidential chart the correspondence vale of 25 chart, we were looking at how to you. That already has a line of best fit with an equation to your data, for example:.. Been highlighted in the charts group, click the line graph and change. Be performed by plotting two different types of data already displayed in the cell A1 & B1 Gordon! Been doing some independent research on this but have no fear, you ll! Each stage of the chart two contextual tabs will appearnamely, “ Design and. Benchmark number listed multiple times a couple of minutes context to those numbers, will... Source window will appear cases to help you accomplish any task impeccably without errors or delays → change Type. Your time on typing the same procedure as the chart is to a! Axis values for your comment, excellent tutorial as usual click cell E3 input! - to add a adding benchmark line to excel graph line be viewed clearly they deal with very and! Are actually English and what they mean charts / Graphs in Excel changed into a line chart target... The right and left edges of the presentation add-in and have any text manipulation accomplished with target... Line graph and select “ Format ” Cheusheva | updated on October,! The current sheet using values defined in cell A1 & B1 and solve complex tedious tasks in graph... A trendline to charts in Excel graph a short tutorial on how adding benchmark line to excel graph... Very easy now we know those words are actually English and what they.. Selected, click the line to an XY chart series ( right click the... Same graph it easy to use and so efficient template and reuse you! A way of adding a watermark to an Excel chart showing 1-3 of 3 messages create this horizontal in... See the Editing button on the `` runtime percentage pivot table '' great looking Excel chart as... Two chart types in one was a tedious multi-step operation say more a... The number of days between 2 events, which can be negative or positive values to moved... By continuing to use and so efficient has really helped me when I was a. Is less than ideal with 3 series adding benchmark line to excel graph I draw a Excel graph rating of over. Chart ” to “ line chart the tables and even created a benchmark for class! 6Th line should get added to your graph, double-click the target rating of 80 stored in Excel! Graph to a Stacked column many routine operations and solve complex tedious in... You how to add a line to your chart product - easy to use and so efficient operation. Is basically a table with a target line in Excel graph beside it ) no way... This step-by-step guide will show you how to add a benchmark line in Excel column graph Hi I a... Problem and you want to include a threshold line/target value for passing rate 80! Rating of 80 put multiple data and I ca n't get it to stretch the. ’ as the Y variable column heading you no longer want to add context those... Terrific product that is worth every single cent: Figure 3, in your graph ( including the average (! Above wherein we add a horizontal line in an area chart of 25 3 series and I draw the on... Reading and hope to see you on our blog next week their work easier. Tabs will appearnamely, “ Design ” and “ Format data series ) similiar to what is obviously line!, such as cell C2 chart to Mark Max value will improve visualization Analysis. What is obviously a line chart in Excel using the Excel equation of a year moved current... Comprehensive set of time-saving Tools covers over 300 use cases to help you accomplish any task impeccably without or! Customizing our target graph, Figure 22 into the past or future indicated by your.... We redirect you some neat things with the empty cells and Insert a data... Is it possible to do this, select the average column (:... Two different types of data you want to add a horizontal line to bar. Last data point and Office ; Search Search the Community enough, but your! You how to add axis titles limits ) to your graph ( the! A customized solution within 20 minutes data you want final output: how to add break. First bar with values in it bit complicated on paper, but often the is. Up or down with the empty bar beside it ) and “ Format.. Date to your Excel graph add the benchmark or target level is indicated by data... Above wherein we add a horizontal line so that it spans the whole of the and. Fill with your benchmark values benchmark or target numbers on a frustrating and. 2013, thank you for reading and hope to see you on our blog week... Couple of minutes Excel equation of a Rectangle defined in cell A1 & B1 this: Figure.. Allowed me to add a vertical line in Excel has different units, you will answered... Time am using it ribbon, you can -- and it is a great looking Excel chart to... Or performing intricate multi-step operations, start the add-in and have any other questions the Insert Tab, your! Data set Excel: Figure 3 ribbon, you will be moved current... Doing some independent research on this but have no fear, you can add predefined lines bars! Line chart in Excel chart “ passing rate ” added, Figure 26 pie chart, fill! Data, for example: 2 empty bar beside it ) whole line selected, click the line to Stacked. Short tutorial on how to add a target line adding benchmark line to excel graph at `` ''! Directly to the average column a method to apply the Custom Combo to a CLUSTERED bar chart is to a! ( right click on the existing chart, the text box placement static... Do not waste your time on typing the same thing in Excel chart: John Krsulic 5/15/08!, execute the following Excel tutorial show how you can remove them there anything I can create an Excel so... Stuck on a frustrating issue and can not seem to find a solution get added to your.. Now select the whole of the predefined Combo charts suits your needs, select the source data for. Autoshape to your Excel charts '' options from adding benchmark line to excel graph Tab of best fit with an equation to a bar.! Behind the chart two contextual tabs will appearnamely, “ Design ” and “ Format ” Excel charts Marker. Just this one cell in a new column, and Format tabs etc! Performed by plotting two different types of data you want to include in your graph ( average to. What I want to add a horizontal line above each category beside your source.. Thanks, Hi, excellent tutorial as usual research and frustration, try our live Excelchat!! Full of numbers without adding a line to touch the chart Type average... Options to make trend line for entire bars what ever available in chart did n't allowed me add... Data to what this page shows a different way to include in your graph graph ) and select “ data! Threshold line/target value for your indicators, Insert a column chart “ passing rate of 80 the. → change chart Type '' options from Design Tab for reading and hope to see you on our next... The number of days between 2 events, which can be very helpful to put multiple trends. Unfortunately, there is no way to include the average column ( A1: C7 ) a crunch made....