An Example Of A Chart Is A Column Chart With A Line Chart

This is for data that deals with time. For example, if you are creating a waterfall chart as a visual for a profit-and-loss statement and the first figure is 1,000 while the second figure is -2,000, part of the floating column will be above the x-axis and part will be below. For a "Line" graph, a series would be one line. The column charts listed below on this page are free to download and edit in many formats including pdf, ppt and word. First select the sales data in 4th, 5th and 6th row. Trend Chart Definition: Trend charts are also known as run charts, and are used to show trends in data over time. Let’s create a Gantt chart in Excel By using conditional formatting we can easily create the following. A few highlights of the June release are the addition of data bars to tables and matrices, markers for line charts, new map themes, and a horizontal image slicer. It can be quicker decipherable by your readers. We will also explain, How to Display Percentage Values as Labels on Column Chart and Calculating the Average of Column Chart in SQL Server Reporting Services with an example. This program is an example of creating a simple column chart: ##### # # An example of creating a chart with Pandas and XlsxWriter. As can be seen in this example, you can easily see the increases and decreases each year over different years. Chart function. Select the columns that track the burndown. Chart control can be found in Toolbox(. To recognize between positive and negative values, we’ll use a color-coded stacked column charts. Its a Visual Studio project you download and run it for a very cool list of chart things. For example, in this image, you can see that there is a bar chart for the sales volume of those sales representatives. Click Clustered Column. There are also some other ways to add a vertical line but I found this method quick and easy. A column chart has the following sub-types − Clustered Column. To use the line chart, you must have a date field. This example makes use of the RSI indicator to pinpoint a reversal. Column charts display vertical bars going across the chart horizontally, with the values axis being displayed on the left side of the chart. Scatter is often called XY chart. Column Sparkline Chart A Column Sparkline is a kind of column chart with minimum number of options enabled by default. The typical chart (or graph) in Excel 2010 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more. A column chart is a primary Excel chart type, with data series plotted using vertical columns. Do you use waterfall charts in your roles and visualizations? If yes, how do you create them? Do you think this tip is useful? Do let me know your thoughts on using this chart in Qlikview. beforeRender jQuery custom event. An area chart represents the change in a one or more quantities over time. The number of students. Another way to find this panel is to select the chart, then go to the tab ‘ Design ’ in the Office ribbon, click the menu ‘ Add Chart Element ’ ► ‘. Displaying conditional colors in a column chart Excel 2016 2013 2010 To emphasize differences between data in the chart it will be interesting to create a column chart in which the color of each column depends on the value displayed. Highcharts column line and pie combination chart with examples. The bars can be horizontally or vertically oriented. This chapter describes the line chart, a type of two-axis chart that presents data as a series of points connected by straight lines. A solid 1-day SMA was added to better highlight the AD Line. If you look closely at Example #1, you’ll also find a small window right after the Piercing Line pattern. What I would like to do, is to have the budget for all the months of the year present in the chart as a line, while the columns of the actual sales would show up as the sales are made. You get a column chart with a second set of columns, or a line chart with a second line. A column chart is a vertical bar chart rendered in the browser using SVG or VML, whichever is appropriate for the user's browser. Up-down bars connect the first and last line chart data points in the chart, which are columns B and E in this example (columns C and D contain the plain old data points). Add a Vertical Line to a Column or Line Chart: Series Method. This is set to true for a category scale in a bar chart while false for other scales or chart types by default. It is also commonly referred to as a ‘bridge chart’ since the floating columns create a bridge-like view connecting the endpoints. Just check the series group name, where Year column is placed in the chart, in my case it was like  Chart1_SeriesGroup. Step 1: Create a sum of your stacked components and add it as an additional data series (this will distort your graph initially) Step 2: Right click the new data series and select “Change series Chart Type…”. I use combination charts a lot and I think you must know how to create them as they are very useful. It shows tasks in a Security and Access Control project. Can't find a clustered column chart example Daryl posted over 8 years ago I am trying to build a clustered column chart like the attached screenshot, but can only get one data point per x-value (country). Your data has to make sense when added up to a total. Because Western cultures are used to seeing time progress from left to right, you are likely to choose a chart where the axis moves from left to right—whether it is a column chart, line chart, or area chart. This is ideal if you want to give a quick overview of something as you would do with a bar chart or column chart but add more information with the help of additional columns. Just copy and past the string from the browser into the argument state of the options list. For example if you selected the entire column C and copy-pasted that on to your chart, Excel will truncate the data series to ensure that source range only extends up to the last cell used (rather than taking the entire column as the source data range). In the picture below, is an example of a line chart showing unique visitors to Computer Hope. Column chart and line chart are two different chart types in Excel. In this case, we focus on sales. Creating a Material Line Chart is similar to creating what we'll now call a "Classic" Line Chart. Attached is an example that combines a stacked multi-colored bar with multi-colored lines. A bar chart is particularly useful for displaying data such as gender, ethnicity, occupation, types of discharges, and treatment categories. Change stacked bar colors. Each column is color-coded for easy reference and to highlight number patterns. The example below shows the NYSE AD Line with the NYSE Composite in gray behind the AD Line. For example, for a pie or column chart we may want to order the data by value. » Line-Column Chart. Floating column charts are a good example. Labels should be in the leftmost column. Pie and stock charts require a column or row with data and another with labels. visualization. An example of converting a Pandas dataframe to an Excel file with a column chart using Pandas and XlsxWriter. Individual data points are joined by a line, drawing the viewer’s attention to local change between adjacent points, as well as to larger trends in the data. As you can see from the example below, the Bar Chart is basically a grid sheet with the construction activities listed vertically in the first column and a time line across the top in the first row. The Bar Chart is like a Column Chart lying on its side. You can see that the values are on the vertical axis (Y-axis) and on the horizontal axis (X-axis) are still only the sequence numbers. For example, in this image, you can see that there is a bar chart for the sales volume of those sales representatives. For example, the second chart listed (under 2-D column) is a good choice. Chart function. The SciChart WPF Examples Suite demonstrates 2D & 3D WPF Chart types, as well as featured apps which show the speed, power and flexibility of the SciChart. This program is an example of creating a stacked column chart: ##### # # An example of creating a chart with Pandas and XlsxWriter. This article assumes that you already have a list to which you want to connect the chart. There are also some other ways to add a vertical line but I found this method quick and easy. In Excel, we always need to create charts comparing different types of data. Following is a short video on creating a combination chart in excel:. 'this chart shows the changes in the cost of oil in the last year'. Line graphs, however, plot a series of related values that depict a change in one variable as a function of another, for example, world population (dependent) over time (independent). Subgroup Size Remaining Constant For setting up the np chart we used the following situation: Suppose that a course has 50 students, and roll is taken at each class meeting. We support a number of different chart types like: bar charts , pie charts , line charts , bubble charts and radar plots. Related charts: Stacked area chart, 100% stacked area chart, Stepped area chart, Stacked stepped area chart, 100% stacked stepped area chart Column Use a column chart to show one or more categories, or groups, of data, especially if each category has subcategories. How do you add a nice vertical line to a column or line chart, to show a target value, or the series average? The method involves adding a new series, applying it to the secondary axes, and making the secondary axes disappear. You may also see monthly chart examples & samples. I want to add an average line for one of the data categories. I have a multi-series column chart (3 in this case). The XML source can be prepared manually, or generated dynamically using any scripting language (PHP, ASP, CFML, Perl, etc. Excel, out of the box, can do one or the other but not both. Column chart in Excel is a way of making a visual histogram, reflecting the change of several types of data for a particular period of time. So if we take the width of the canvas as 500 pixels, an average of 20 data plots will be drawn every width of a pixel which is not very informative with respect to visualization. The vertical red target line and the horizontal black line separating Model 1 from Model 2 are real-life examples of Adding a Horizontal or Vertical Line to a Column or Line Chart. Edit this example. We can also turn the chart legend off, like the previous examples, or position the legend. Column charts can be used to make histogram charts by setting the padding between points and groups to 0. The Bar Chart. It is very difficult to see any reasonable use of any of the faux 3D chart forms if the intention is to accurately convey information. Example 7-1 creates a bar chart with three series of data to present financial information about five countries. This is set to true for a category scale in a bar chart while false for other scales or chart types by default. Count and Percentage in a Column Chart Deepanshu Bhalla 4 Comments Advanced Excel , Excel Charts This tutorial explains how to create a column chart in which we can show both values and percentages. For example, in this image, you can see that there is a bar chart for the sales volume of those sales representatives. A Gantt chart is a type of bar chart, adapted by Karol Adamiecki in 1896 and independently by Henry Gantt in the 1910s, that illustrates a project schedule. When you start a new business, you set up your chart of accounts as a first step in establishing your company's accounting system. On the Insert tab, in the Charts group, click the Column symbol. A simple lightweight jQuery plugin that makes use of canvas & Javascript to produce an interactive Line, Area, Scattered, Bar, Hybrid, Pie chart with many configuration options. The Bar Chart, or Gantt Chart, is a visual presentation of the sequence of construction events for your new home. Since spark lines are effectively tiny bar charts, we can use much of the same code as before to make this example: See the Pen Simple bar chart in SVG by CSS-Tricks ( @css-tricks ) on CodePen. When you are comparing values in a bar chart, it is useful to have some idea of what the average value looks like relative to the data set. Create an XML source to describe a chart, then pass it to this tool's flash file to generate the chart. Then, in the Insert menu tab, under the Charts section, choose the Stacked Column option from the Column chart button. The Actual values are displayed as a clustered column and the forecast data is displayed as a line - all on the same primary axis. In other words, I'd like to see the relation between a person's performance and the whole group, by using dots(to show individual's value) and line charts(to show a group's average performance). So in this blog post, I’ll show you how to make a line chart with ggplot2, step by step. Also if you are trying to display a large number of data sets on the category axis, for example when you are trying to compare the amount of rainfall in a year. A column chart is a graph that shows vertical bars with the axis values for the bars displayed on the left side of the graph. Switch rows and columns in a chart. js: Radar and Polar Area Charts In the first introductory Chart. Whenever the null api value comes, the chart disappears. 1 With 12 or fewer data points,column charts are viable and informative. 5 – Part 1 Microsoft Chart with ASP. Pro Tip: Since a Clustered Column chart is a default Excel chart type (at least until you set another chart type as a default type), you can select a source data range and press ALT + F1 keys on your keyboard. For older students, you may want make a K-W-L-S chart, with the fourth column focusing on what students may “still” want to learn even after completing research. compares trends over even time intervals c. Edit this example. Rectangular bars are placed along the category axis with bar length representing the value for a specific category. Area chart - Area charts are used to represent cumulated totals using numbers or percentages (stacked area charts in this case) over time. Generally the bin sizes should be equal, but since the values are percentages of a population, as opposed to absolute values, it is ok to have different size bins. Add Horizontal Average Line to Vertical Chart. You may also look at these useful functions in. You are then going to populate the cells with the different data. In fact, you can combine far more than two chart types by repeating the above process with additional data sets, and selecting a different type from the Change Chart Type dialog box. Step 1 Open a Microsoft Excel worksheet containing the data you wish to chart in a cumulative graph. When you start a new business, you set up your chart of accounts as a first step in establishing your company's accounting system. There are two methods to add 3D column charts in Excel. Charts are a great tool for communicating information visually. Response: A first attempt to set up a suitable line chart is made by the application. To handle showing thousands of data points, Fusion Tables automatically buckets the data and identifies a value to represent each bucket, creating a representative line at. After looking at the long term growth of the stock price, it occurred to me that visualizing the stock price data would be a great example of how to create a line chart in R using ggplot2. The lift chart shows how much more likely we are to receive respondents than if we contact a random sample of customers. You may also look at these useful functions in. 1 With 12 or fewer data points,column charts are viable and informative. What if you want to render 10000 data points in a single series chart with a dimension of 500x400 pixels for the line, area, and column charts. 3-D Clustered Column. Sites and applications always use charts to depict data that can otherwise be hard for users to read and understand. Stacked Column. Line Chart: A style of chart that is created by connecting a series of data points together with a line. I wanted to overlay a line over the columns across all series. At this point, we have a usable Gantt chart, but there is still room to add a lot of value in Tableau through formatting, encoding, and reference lines. ,10, 20,30, 40 points) on the chart, but someone's points on the bar. Adding labels to Excel scatter charts. Create a column chart based on. A chart is essentially an ’object’ that Excel creates upon request. Completing the steps below will produce a stock market chart similar to the image shown here and help you make good decisions when planning your stock trades. You have two excellent choices when creating charts that show the progress of some value over time. Right-click on the chart, and click Change Chart Type; In the Change Chart Type window, at the left, select the Combo category. The Basics of Creating Graphs with SAS/GRAPH® Software Jeff Cartier, SAS Institute Inc. A Series is a set of data on the Chart. You can use line chart to show changes in trends over the time. Compare Live Data with a Chart Communicate relationships within your data in real time with a visual chart. Be sure to follow all the Chart Wizard steps and choose the “as object in” option to place the chart in your worksheet (we can change the location of the chart later). Here we discuss its uses and how to create Stacked Column Chart in Excel with excel examples and downloadable excel templates. The rectangles of the column data series are drawn side by side so that you can easily compare their values. Creating a Material Line Chart is similar to creating what we'll now call a "Classic" Line Chart. The Bar Chart. Both are used to compare two or more values. ” Rather, click on one of the red bars in the chart. The picture below is an example of a column chart displaying the unique visitors Computer Hope has received between the years of 2000 and 2006. This provides a combination of both options. We can also turn the chart legend off, like the previous examples, or position the legend. Column Sparkline Chart A Column Sparkline is a kind of column chart with minimum number of options enabled by default. The most common charts are column, bar, line and pie charts. Dual axis charts can be useful when comparing values that have different units of measure. Adding a column chart to a report. Question: I have a question with Excel charts in Microsoft Excel 2003/XP/2000/97. Doughnut charts are the same as pie charts but with more than one column or row of data. The pie and single line charts reflect the data in column B for Vendor 1. As our community members show every day, there are endless inventive ways to visualize your data. Is this possible? In the format section, I'm only able to remove data labels completely, but would like to remove the data labels for the line as that is a static target across all months. Column charts work well in showing data changes over a period of time by displaying the comparisons among subjects on an overall chart. Recommended Articles. A scatter chart ____. The different charts can be easily combined. The chart as a whole represents the sum of all its data; individual slices show each piece of data as a percentage of the whole. What it is: A bar graph is a chart that uses either horizontal or vertical bars to show. Response: A first attempt to set up a suitable line chart is made by the application. With line charts, the emphasis is on the continuation or the flow of the values (a trend), but there is still some support for single value comparisons, using data markers (only with less than 20 data points. This is a Basic Gantt chart example. Rectangular bars are placed along the category axis with bar length representing the value for a specific category. Site License; What's New Leading Causes of Death Line Chart Example. The bars can be either vertical (sometimes called a column graph) or horizontal. Excel doesn't have a Waterfall Chart Type, but you can create one by arranging your data in columns, then adding and formatting a stacked column chart. In accounting, a standard chart of accounts is a numbered list of the accounts that comprise a company’s general ledger. newStack: Boolean: false: If you set it to true, column chart will begin new stack. Highlight a bar in a chart. Also learn the facts to easily understand math glossary with fun math worksheet online at Splash Math. Printable hundreds chart in full color. Out put of the report look like below. This example shows how to display your data in your Windows Forms program as a bar graph or spline chart. Line stroke width generally is not an issue if you only want to visualize flow. A column chart is a graph that shows vertical bars with the axis values for the bars displayed on the left side of the graph. Color: When a column is dropped in this shelf, the chart will be further categorized showing each data point in this column in different colors (different data series) in the chart. see figure below. 3-D Column: 3-D column charts use three axes that you can modify (a horizontal axis, a vertical axis, and a depth axis), and they compare data points (data points: Individual values plotted in a chart and represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes called data markers. combines a column and line chart to compare data requiring different scales of measure. Completing the steps below will produce a stock market chart similar to the image shown here and help you make good decisions when planning your stock trades. 5) in column C, as shown below. To recognize between positive and negative values, we’ll use a color-coded stacked column charts. A solid 1-day SMA was added to better highlight the AD Line. Printable hundreds chart in full color. The following is an example using stock data and positioning the legend at the top of the chart:. The table has two columns, Column A: date, Column B: amount. Create a stacked column chart from all the data, and change the Sales amounts to a Line chart type. This page descibes a method that I developed to create timelines quickly in Excel using an XY scatter chart with events as the data labels. Typically most people create charts with one style such as a column chart, a line chart, or a pie chart. On the Ribbon's Insert tab, click Column Chart, and click the first subtype -- 2D Clustered Column. For example, you can use this to create a Sales trend, Temperate Trend etc. A variance chart plots both the monthly and YTD variances, with a column chart and a line chart. If you want to show change over time, a line graph is probably best. Switch rows and columns in a chart. Chart control can be found in Toolbox(. Basic line Ajax loaded data, clickable points With data labels With annotations Time series, zoomable Spline with inverted axes Spline with symbols Spline with plot bands Time data with irregular intervals Logarithmic axis Line chart with 500k points. A 3-D Line Chart is available, but the Line Chart does not display data well in three dimensions. A Bar chart is oriented horizontally whereas the Column chart is oriented vertically. js tutorial of the series, you learned how to install and use Chart. Like bar charts, column charts can be used to plot both nominal data and ordinal data, and they can be used instead of a pie chart to plot data with a. Short method and Long Method. Timeline Charts. Both - a line chart and an area chart - show a trend over time. BAR CHARTS To create a bar chart from the above highlight the data and headings (here columns A1:B12) and click on the Chart Wizard icon on the toolbar. By using highcharts library we can create a combination chart by setting the required chart properties. Some column chart examples are available to freely download and edit. If you handed in a chart like this, you would probably receive full credit for it. A variance chart plots both the monthly and YTD variances, with a column chart and a line chart. This is because there is one data point per day or week. It's easier to modify an existing chart than to draw a new one. This python Line chart tutorial also includes the steps to create multiple line chart, Formatting the axis, using labels and legends. The Basics of Creating Graphs with SAS/GRAPH® Software Jeff Cartier, SAS Institute Inc. With line charts, the emphasis is on the continuation or the flow of the values (a trend), but there is still some support for single value comparisons, using data markers (only with less than 20 data points. Leave a Comment. In the chart shown in this example, daily sales are plotted in columns, and a line shows target sales of $500 per day. Line Charts. I need to Create a Stacked Column Chart representing 1 set of measures with a Line representing a target. A pie chart serves the same purpose of a line graph and a bar graph in the sense it is designed to show differences between two separate subjects although it eschews the common linear style found in the two other graphs. For example, students may want to decide where to go for a class field trip. Timeline Charts. Column charts display vertical bars going across the chart horizontally, with the values axis being displayed on the left side of the chart. Highcharts dual axes line and column combination chart with examples. Sign in Join. Highlight the copy of the data, and create chart by Insert -> Column Chart -> Stacked Chart. A variance chart plots both the monthly and YTD variances, with a column chart and a line chart. With that in mind, there are two ways you can format this graph. Use line charts, pie charts, and bar charts to display your data in a canvas app. If you need to create a simple Gantt chart, see Creating a Gantt chart or Gantt chart with progress. To achieve this, you use Chart class in System. A fairly common chart that is not a default Excel chart type is the stacked cluster chart or a side-by-side stacked column chart. Select the information you want to include in your run chart. (Though you can use a stacked bar chart to make a Gantt chart. When plotting actuals against budget, it is common to use a standard clustered column chart and display both metrics as columns, as per Figure 1. The picture below is an example of a column chart displaying the unique visitors Computer Hope has received between the years of 2000 and 2006. , Clustered Column-Line). Edit this example. For a horizontal version of this chart, see the bar chart. For detailed implementation, please take a look at the HTML code tab. You'll see that the Chart control has a section called "Series". a line graph would be a. Both the Bar and the Column charts display data using rectangular bars where the length of the bar is proportional to the data value. By default, however, Excel's graphs show all data using the same type of bar or line. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. If the user clicks any month on the small graph, the main graph will change to reflect only that specific month's figures. Then, you have Line charts that are meant to display trends. This example shows how to display your data in your Windows Forms program as a bar graph or spline chart. A column chart is a primary Excel chart type, with data series plotted using vertical columns. These charts are useful for showing trends. Site License; What's New Leading Causes of Death Line Chart Example. A bar graph shows comparisons among discrete categories. lets see with an example for each. Transition. When you work with charts, the data that you import should be structured based on these criteria: Each series should be in the first row. In the below example (Figure 1), we are comparing the quarterly profit by SubRegion over the course of several years. As I said, adding a vertical line in a chart is useful when you want to highlight a specific data point in your chart. As can be seen in this example, you can immediately see a gentle increase of users without reading any data. As you know, the PDCA applied to problem solving involves writing the problem statement based in facts and I had to enter the last twelve months data – rows and rows of information. Subgroup Size Remaining Constant For setting up the np chart we used the following situation: Suppose that a course has 50 students, and roll is taken at each class meeting. Recommended Articles. Grand Total Line on an Excel Stacked Column. I need to Create a Stacked Column Chart representing 1 set of measures with a Line representing a target. An example of converting a Pandas dataframe to an Excel file with a column chart using Pandas and XlsxWriter. Individual data points are joined by a line, drawing the viewer’s attention to local change between adjacent points, as well as to larger trends in the data. Always label each axis (or column) including units!. If none of the predefined combo charts suits your needs, select the Custom Combination type (the last template with the pen icon), and choose the desired type for each data series. But I need to generate the chart with variable number of columns/rows , depending on what my arrays contain and i don`t know how to correctly iterate them and add them to the DataTable. 2) Horizontal Bar Charts. Rectangular bars are placed along the category axis with bar length representing the value for a specific category. For example, you want to show the difference in the percentage of sales between different literary genres. Enter your data into two columns. Adding a column chart to a report. Add a Vertical Line to a Column or Line Chart: Series Method. Line Chart is the graphical presentation format in excel. You'll see that the Chart control has a section called "Series". A line chart is particularly useful when showing trend lines with subtle differences, or with data lines that cross one another as shown in the example below. (Though you can use a stacked bar chart to make a Gantt chart. A column chart has the following sub-types − Clustered Column. When you create a chart to analyze the trend of the data, it is useful to add a horizontal Average Line across the chart, so that you can compare the data clearly and easily. By Excel Tips and Tricks from Pryor. For example, the bar chart at the top of this post is constructed by using the following statements:. Back to top. How to create a column chart and to combine it with a line in Excel. Markers – Whether a column or line chart shows the value of each data point. Once the table is created, I want to use VBA to create a simple line chart. Instead of a formula, enter your target values in the last column and insert the Clustered Column - Line combo chart as shown in this example. Column charts are a good way to show change over time because it's easy to compare column lengths. 2) Horizontal Bar Charts. Step 1 Open a Microsoft Excel worksheet containing the data you wish to chart in a cumulative graph. Simply choose your graph settings, specify your line specific settings and finally paste your data in the data area. A line chart (also known as a line graph) plots a series of data points on a graph and connects them with lines. 2019 12:05 AM Hi ,all. Let us now see the additional configurations/steps taken. When you work with charts, the data that you import should be structured based on these criteria: Each series should be in the first row. lets see with an example for each. In our example type is 'line' because we want a line chart. Example: Below is a line chart showing the sum of sales for two different product categories over several years. You can use these methods to set up a chart that can be automatically updated when you add new information to an existing chart range. Continuing the above example, if you want to create Date-wise Sales by Region chart, drag and drop Region column in to the Color shelf. It uses vertical bars (called columns) to display different values of one or more items. My chart looks like this:. Rectangular bars are placed along the category axis with bar length representing the value for a specific category. If you’d like to follow along at home, you can fork this jsFiddle sample project. For example, if a line graph represented the height of water in a reservoir over time, shading the area under the line could make the line graph look like actual water rising and falling. Ajax Control toolkit provides a ways to create Bar Chart that would be display the statistics data in graphical representation. The X-Axis is _time, Y_Axis(left) is count_num1 and count_num2. Step 3 Now preview the report and you will find the result as shown in the below screenshot. Column Line Column 2D + Line Column 3D + Line. For a "Line" graph, a series would be one line. Notice that it’s impossible to visually compare the two sets of rates. Response: A first attempt to set up a suitable line chart is made by the application. Adding a column chart to a report. An Illustrated Tour of the Pie Chart Study Results In two papers , Drew Skau and I recently showed that our idea of how we read pie charts is wrong, that donut charts are no worse than pie charts, and a few more things. Such charts use the Y vertical axis for numeric values & X horizontal axis is meant for displaying the time or some other category. An example of each will be given. But one important thing. This has been a guide to Stacked Column Chart in Excel. For example, if your chart displays revenue by product line by year, the cumulation line at the second year's column would be the total revenue of the first and second years.