How To Add A Percentage Line To A Bar Graph

You can change the y-scale on a bar chart to a percentage scale, a cumulative scale, or both. A bar graph or a line graph can illustrate the vast majority of data; they’re the two workhorses of the dataviz world. Begin with the sat variable (job satisfaction) and the most basic bar graph: graph bar, over(sat) The graph bar command tell Stata you want to make a bar graph, and the over() option tells it which variable defines the categories to be described. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then this is the chart for you. Now calculate the percentages you want to appear. Bar graphs convert the information in a chart into separate bars or columns. The procedure to create a line chart or line graph in Google Doc. Modify the Secondary Y axis (Categories) scale so that the scatter chart data points line up with the bars from the bar chart. The graph #180 explains how to make a lollipop plot with Matplotlib, whatever the shape of your data. Easily change fonts, colors, and backgrounds. The issue is that i need to show market share percentages (assume the 5 companies is the universe - i. Then we want to create new columns showing how much each tree has grown between data points. As you’ll see, we can include a lot of information in a small space with this type of chart that is also Tableau’s answer to those looking for. A bar graph, basically a horizontal column chart, should be used to avoid clutter when one data label is long or if you have more than 10 items to compare. We have a collection of printable line graph worksheets for you to use with your students. Max Height of a peach tree vs Max Height of Apple tree, etc. Required User Permission: 'Standard' level permission or higher on the project's Reports tool AND 'Read Only' level permission or higher on the tool being used as the data source (e. Since the post-financial crisis era began more than a decade ago, record low interest rates and the Fed's acquisition of $4 trillion of the highest quality fixed-income. In the former article, we have discussed about adding horizontal line into the chart. You may select a bar graph when your independent variable is qualitative (categories) or quantitative (numbers). For example, if you copied the data from a bar chart and pasted it into a line chart, the final result will be a bar chart. Add impact to your web site with pie charts, line graphs and bar charts. This is optional—the number of columns and rows required for a graph are dependent on the type of graph you choose. Each graph types used for different purposes. Calculating percentage increase allows you to learn how much the variable being measured has grown compared to its initial amount. Fitting data to a Straight Line Graph. How Can the Mean, Range and Mode Be Found on a Bar Graph? To find the mean, range and mode on a bar graph, analyze both the x- and y-axis. This Graph Worksheet will produce a bar graph, and questions to answer based off the graph. We want to stack those 4 values up, but since it’s going to add them together, we. How To Add Standard Deviation In Excel Bar Graph You can add error bars to data series in a 2-D area, bar, column, Express errors as a percentage,. 44 inch ILI9163C 128 x 128 display. You can use bars, lines, or a combination of the two to visualize your data. Harrie wants to create a column chart that displays two values for each column in the chart. A couple of other optimizations for a percentage bar chart. The first step is to add a dataset to ArcMap that will contain the data values to graph. It is clear that the proportion of elderly people increases in each country between 1940 and 2040. I can easily create a Pivot table / charte using Product in the value and row category to get either the Count for car and ship 3 and 2 or the percentage 60% and 40% and the coresponding bar graph. Use “File/Save project” as options from the menu bar to save your worksheet onto a flash drive as. However, with your basic line and bar charts, it is difficult to track seasonal variation and to compare one year to the next directly. W hen plotting Actuals and Forecasts on a single line chart you may want to use a vertical dotted line to identify where the Actuals finish and the Forecasts begin. -graph bar- and -graph twoway bar- draw Stata (vertical) bar charts. 5%? When I try and represent this tabulation into a graph bar using the following command:. My problem is that I want to show an average for a stacked bar graph, similar to the one shown: My idea was to have another bar that just has the averages of each of those stacks on the top, and the lines at the end of those bar goes down so that they are a good reference for each of those metrics. A bullet graph is a very powerful way to compare data against historical performance or pre-assigned thresholds. For more details, download the Quick Start Guide from the Kaleidagraph web site. Horizontal Bar Charts in R How to make a horizontal bar chart in R. In drawing a percentage bar chart, bars of length equal to 100 for each class are drawn in the first step and sub-divided into the proportion of the percentage of their component in the second step. That means in situations when a time series plot or stacked bar chart is not appropriate for data, neither is an area graph. It can be very helpful to put multiple data trends onto one graph in Excel. I even tried turning chart to table and then formatting number but when I reconvert it back to chart then complete formatting goes off. i have a graph (LOOKGRAPH VBRSTKPC). Additionally, we will make our graph interactive with a scroll bar: Insert vertical line in Excel graph. EXCEL 2007 Charts: Column, Bar, Pie and Line A. And because almost everyone is very familiar with this type of visual, you won't have to explain how it works. They require to see a vertical bar graph with a displayed percentage of total used bandwidth. It shows the relationship between sets of similar statistics for two or more items. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then this is the chart for you. Since the post-financial crisis era began more than a decade ago, record low interest rates and the Fed's acquisition of $4 trillion of the highest quality fixed-income. Matplotlib’s Bar charts, in contrast to line graphs and scatter plots, are useful for discreet categories that have amounts (often counts) associated with them. Bar Graph Tutorial: Bar graph examples and enhanced solutions using graphing images. Adding a benchmark line to a graph gives loads of context for the viewer. Add a grand total to the table Include the grand total in your stacked graph range Select the grand total series and plot the series on secondary axis Change the grand total chart type to line (no markers) Select the grand total line series, right click and add trend line. Has anyone done this before?. Equally, while the title of the graph is ‘US Homelessness by Race / Ethnicity', the term ‘homelessness' may need to be adapted to fit grammatically within a particular sentence, e. However, in Microsoft Excel, a bar graph has horizontal bars whereas a Column Chart has vertical bars. Printable Percentage Chart: Customizable - HelpingWithMath. The calculation would be =B4/B3-1. I have three data fields in which two data fields(in percentage values) in vertical bar chart and third data field(in numbers) in line chart. Displayed as a bright green line. We can show that on a bar graph like this: It is a really good way to show relative sizes: we can see which types of movie are most liked, and which are least liked, at a glance. The linked picture will explain more precisely. Learn how to create a Bar-Line chart in Excel when you want to display two different measures with different scales. Add a pie chart to your report. when you open up the file please ignore everything above the blue bar. How to add a label for Percent of Total (of one mark) so that the percentage is displayed on the end or top of the stacked bar chart. It is not easy to create this visual appeal by using chart functions in Excel alone. For more details, download the Quick Start Guide from the Kaleidagraph web site. Select the small Pie Chart icon from the Charts section. See more of ̸Ҳ̸ҳ[̲̅B̲̅][̲̅7̲̅][̲̅B̲̅][̲̅K̲̅]ҳ̸Ҳ̸ on Facebook. The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. Obviously, the phrase "line graph" means something different, to the Microsoft Excel programmers, than it does to most of the rest of us. Now you can read the below steps to add percentages in stacked column chart in Excel. When to Use a Bar Graph. Right Click on the Profit Series and change chart type to a line graph. It’s so easy you might pass out. 6%) was almost. First, it’s good to think about the end goal in communicating data. We need a total cell that gets the sum of values from a list. So there are several different types of charts or graphs you can make in matplotlib, including line plots, bar graphs, histograms, pie charts, scatter plots, etc. On the Chart Design tab, click Add Chart Element, point to Up/Down Bars, and then click Up/down Bars. Add a pie chart to your report. The graphs are designed based on three unique themes. Adding labels to ggplot bar chart. A variation of the stacked bar chart is the 100% stacked bar chart. Standard Deviation. For more details, download the Quick Start Guide from the Kaleidagraph web site. If this was a simple bar chart I could add the target scores as new series and use the line chart type but I don't seem able to overlay a second series on the stacked bar chart. A segmented Bar chart is one kind of stacked bar chart, but each bar will show 100% of the discrete value. Task 1 is some kind of data report, while Task 2 is an essay. NOPLANE affects only the axis to which the AXIS statement applies. NET Forums / Advanced ASP. As well as bar graphs, there are also some picture graphs on this page, where one picture represents more than one unit. Drag a dimension to the Columns shelf. While your data might work with multiple chart types, it’s up to you to select the one that ensures your message is clear and accurate. Open the image containing the graph. I'd like to put the percentages right at the top of each corresponding bar in the graph, but can't figure it out. So the bar for 'Cat 1' would be represented as 43. One axis of the chart shows the specific categories being compared, and the other axis represents a measured value. Matplotlib’s Bar charts, in contrast to line graphs and scatter plots, are useful for discreet categories that have amounts (often counts) associated with them. This Excel tutorial explains how to create column/line chart with 8 columns and 1 line in Excel 2003 and older versions (with screenshots and step-by-step instructions). **I revised the numbers in the pie graph on this from the first version, these amounts are much more friendly** This activity includes construction of a bar graph, double bar graph, line graph, double line graph, and a circle graph. How to Read a Stacked Bar Chart. Adding a Median Line In order to analyze the chart, you need to add in a median line. I read that it was not "natively" possible. The line where we create plot using the figure function is where a lot of the magic happens. We want a stacked area graph. Fitting data to a Straight Line Graph. Useful when creating excel dashboards and you want to include a threshold line/target value for your indicators. 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. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code. The following section shows you how to add this macro to your standard macro library. The first is a spacer segment that adds some distance between the end of the last segment and the total value. Similarly, for assignment statements, the last character on a continued line is an operator. I am pretty new to Webi, and I am trying to create a Vertical stacked bar and line chart. Solved: I have a very specific set of requirements by my customer. Required input. Highcharts - Interactive JavaScript charts for your web pages. In this case, the height or length of the bar indicates the measured value or frequency. Out of them, 25 students like Basketball, 30 students like Volleyball, and 20 students like Badminton. If the values change the heights will animate from the old to the new value. Create a customized Bar Chart for free. It’s not uncommon to be asked to add additional analysis to your visualization that typically isn’t plotted on an Excel chart. A bar graph or a line graph can illustrate the vast majority of data; they’re the two workhorses of the dataviz world. Combo charts combine more than one Excel chart type in the same chart. Easy to set up, add to and change. Cumulative percent graphs are a way of showing a distribution. I read that it was not "natively" possible. Trustpilot, an online review platform, faced a problem that most companies are dealing with these days: how to build AI to meet business goals or solve problems — from scratch. the main difference with line charts is that the horizontal axis is an equally spaced category axis. This scales the vertical size of the graph When keepAspectRatio is set to false, and verticalRatio is set to 1. The bar graph we are going to create displays a list of rectangles of varying height proportional to the values they represent. Idea is basic, while one series is static, other will be dynamic, changing as we input data. Adding a benchmark line to a graph gives loads of context for the viewer. 44 inch ILI9163C 128 x 128 display. In the end it should look like what you created. 1 State the fundamental units in the SI system. In reality, the final product (a beautiful and insightful graph) deserves more thought than that. I want to combine bar chart with Box plot in a same graph in R Studio using ggplot or without ggplot may also work. They are on the secondary axis now. There are a couple of ways to make a simple bar chart in CSS. They are used for personal, educational,… Continue Reading →. Encourage your students to use range, mean, median, mode, and outlier when they describe data sets. Obviously, the phrase "line graph" means something different, to the Microsoft Excel programmers, than it does to most of the rest of us. Add Target or Goal Lines to Control Charts Use Goal or Spec Limit Lines to Compare to Targets. The bar graphs in Examples 1 and 2 each have horizontal bars. I have to work with bar charts and I would like to show the actual values as well as the percentages. By default it will tell you the percentage of observations that fall in each category. CSS Bar Charts. Here are the steps to do that: Preparation work done, here are. is composed of discrete bars. It is common to want to apply a configuration setting to all created bar charts. Learn "how to make a single line graph in Excel" in a short way. For example, there are a total of 40 students in your classroom. We want a stacked area graph. thanks for your support. Line graphs are appropriate only when both the X- and Y-axes display ordered (rather than qualitative) variables. Depending on the chart type, some options may not be available. By adding a label with percentage, we will have a progress bar chart. Hello, I would like to create a stacked bar chart (colored by DATE) and display a line on the same graph. I know how to make a chart with the values and I know how to make a chart with the percentages, but it seems like I can't show both in one chart (well, I'm not too talented with excel). This technique just uses a doughnut chart and formulas. To add events to your Gantt chart, see Progress Gantt chart with events. A VERSION IN WORD IS AVAILABLE ON THE SCHOOLPHYSICS CD. Environment Tableau Desktop Answer Create a dual axis graph with the stacked bar on one axis and the total/label on the other axis. Add Standard Deviation To Excel Graph Mac need to add your SD. , independent-samples t-test, paired-samples t-test, one-way ANOVA or repeated measures ANOVA), rather than just descriptive statistics, you may also want to include "confidence intervals". - under Legend Entries click Add. On Onlinecharttool. These lines monitor and compare various data sets. 8 (which is technically 80 percent). I want to display the percentage of employees complete and incomplete by section in bar chart. Cumulative percent graphs are a way of showing a distribution. Since I don't think we have dual-axis (to make the line on a different scale (0-100%)), I am trying to make it scale to the current axis. If you need to create a simple Gantt chart, see Creating a Gantt chart or Gantt chart with progress. Add Reference Lines to Pareto Chart in Tableau. The chart displays the Series name and the Values names at each data poins in the line - Which ever chart type you select. A divided bar graph is a rectangle divided into smaller rectangles along its length in proportion to the data. Create New Account. In most cases, the line will be the median of all the data points that are on the chart. Create Variables. A bar chart is created similar to a line graph, except that you use GraphPane. Luxury 30 Sample Excel Bar Chart Add Line Graph. While I could easily do this (inbound/outbound) on a graph I’ve been told this isn’t a viable solution for the consumer of the dashboard. 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. A group line graph is also known as Comparative line graph, Composite line graph, multiple line graph, Polygraph. Usually, the x-axis represents time measurements while the y-axis is a representative of measure or percentage of quantity. Bar charts and histograms are easily to understand. How To Add Standard Deviation In Excel Bar Graph You can add error bars to data series in a 2-D area, bar, column, Express errors as a percentage,. A stacked bar graph is actually what we want. Line chart spike protection (max. I often write for non-specialist audiences so I tend to use them a lot. Treatment///// % open stomata KCl (pH 7) in light ///// 72. The tech stack for this site is fairly boring. Attaching the screen shot of the image which I would like to replicate. Adding a Line to a Stacked Bar Chart in SSRS 2008. Add to Likebox #53562811 - Growing graph line. Drag the measure that will be the bar chart to the Rows shelf. Shade the area under lines. Unfortunately, I am neither a programmer (per se) nor am I a math major, so I am looking for help on how to enhanced my current formula to come up with a percentage instead of a number. In this lesson, you will learn the definition of a bar graph, including how to recognize the different types of bar graphs. This chart sits on the top of the original chart. Highcharts - Interactive JavaScript charts for your web pages. I would like to fill in part of each bar based on a percentage. We can show that on a bar graph like this: It is a really good way to show relative sizes: we can see which types of movie are most liked, and which are least liked, at a glance. Mean (±SEM) percentage of open stomata in leaf tissue incubated in KCl (pH 7) in the light or in the dark for one hour. Your basic choices are bar graph, line graph, pie chart, or scatter plot. Adding reference lines: chart > reference line > select axis > type in position of line, click on "add" and then on OK. CSS-Tricks * is created, written by, and maintained by Chris Coyier and a team of swell people. The global bar chart settings are stored in Chart. What we want is a combination of the two graphs. Source: visualcapitalist. Calculator assumes a constant rate of interest. This Graph Worksheet will produce a bar graph, and questions to answer based off the graph. Change the foreground of the points to black 4. Max Height of a peach tree vs Max Height of Apple tree, etc. Use vertical bars. Showing percentages above bars on Excel column graph. hi all, I'm very new in Webfocus. Free Online Chart Generator ,Choose From Different Chart Types( Line - Bar- Stacked bars - Radar- Polar Area - Pie - Doughnut), based on ChartNew. I can easily create a Pivot table / charte using Product in the value and row category to get either the Count for car and ship 3 and 2 or the percentage 60% and 40% and the coresponding bar graph. Please make sure you are in the correct subject. I like how they displayed the variances between years, and decided to recreate it in Excel. Performance Monitor allows you to add your required counters so that you can analyze its performance on your system. Each bar chart has a series of questions that include subtraction and addition (LA just addition). To produce a simple bar chart: 1. Creating a mass spectograph, where symbols on the XY plot are replaced by "spikes", or bars of zero. In the box that opens up, change the line color, marker fill color, and marker border color all to a medium-light shade of gray. A bar graph that directly displays the difference between the first and second values in each time series People often use the approach illustrated in the two bar graphs below, but this is of. " However, your percentage will not be a percentage of 100%. You can change the y-scale on a bar chart to a percentage scale, a cumulative scale, or both. Create a calculated field with the value of 1. Ideally instead of the sum i would like the percentage of that segment to only be visible over the Sum. In reality, the final product (a beautiful and insightful graph) deserves more thought than that. When I tell it to add values, it adds the dollar value. That means in situations when a time series plot or stacked bar chart is not appropriate for data, neither is an area graph. For each bar, the corresponding percentage(y axis) is put in the top of bar. These include 1 and 2 step problems. Although bar graphs can also be used in this situation, line graphs are generally better at comparing changes over time. In the spreadsheet, I also have a range of cells showing the percentage growth from year to year. Calculating percentage increase allows you to learn how much the variable being measured has grown compared to its initial amount. In the Format Data Labels menu you will see a Value From Cells option. Bar stacked - bar graph, accepts multiple values and displays them on top of each other. Add a trend or moving average line to a chart in Office 2010 Add a trendline (Office 2010) 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:. I would like to Show the bar graph with Count at the y axis and Show the percentage on top or within the bar (similar to think cell). I did it, added a plot line as the chart type and created a second axis - line was showing with the calculated values and formating, etc but behind the stacked columns - I couldn't find a. Create Graphs Easily with SigmaPlot! SigmaPlot´s Graph Style Gallery: Save any graph with all graph properties and add a bitmap image to the gallery to create complex graphs; Graph Toolbar: select toolbar icon of the graph type and style you want to create or to add additional curves to an existing graph. You can add multiple reference lines, using different reference line types, to the same Graph visualization. Difference between bar and line graphs: Line graph shows change in a long period of time and bar graph shows bars showing different amounts. I would like to Show the bar graph with Count at the y axis and Show the percentage on top or within the bar (similar to think cell). This tutorial walks you through some options. Percentage bar graph maker keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. To add events to your Gantt chart, see Progress Gantt chart with events. Here you will find our range of bar graph worksheets for 3rd graders which will help your child to read and answer questions about different bar graphs. The following instructions are based on Superstore sample data. The wizard offers column, line, pie, bar, and area charts. I need left side Y axis should be in "percentage" and right side Y axis should be in "numbers". Column Chart With Percentage Change. So again, I'll take the sum of value and this creates two different charts within one visualization On the second chart, I'll hit the dropdown I'll select a quick table calculation and go for percent of total Unfortunately, this doesn't calculate the percentage of total value by week. Select the data. (chart with x and y axes) grafico a. A relative frequency bar graph looks just like a frequency bar graph except that the units on the vertical axis are expressed as percentages. Our charts and graphs are easy to use and free!Find out more: Pie Charts Bar Charts Line Graphs. I would like to create a bar graph with a target line Use a standard column chart and use the "Analytics" pane to add a constant line. Add a pie chart to your report. In line charts, interpolation can be enabled and disabled for individual series in a chart. 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. They organize and present data in a clear manner and show relationships between the data. Here, we use -graph bar- to draw stack bar graphs (figures 1 and 2). Very easy to use and it's perfectly possible to add professional quality real time graphing to web pages & apps within minutes. Enter text inside the box. We can use bar graphs to show the relative sizes of many things, such as what type of car people have, how many customers. Though, i want one line to change into circle chart. Insert a pie chart. With the help of Excel, the graphical analysis of pie charts has become popular and easier. This will give you the percentage change. Excel graph percentage and number keyword after analyzing the system lists the list of keywords related and the list of websites with related content, in addition you can see which keywords most interested customers on the this website. A simple bar graph with a harmonic mean average. The graph #180 explains how to make a lollipop plot with Matplotlib, whatever the shape of your data. But how do you combine a line chart and a bar chart, all on the same chart? The trick is to combine bar chart and XY scatter chart, then clean up the axes. Open the thresolding tool (shift-t). I want to combine bar chart with Box plot in a same graph in R Studio using ggplot or without ggplot may also work. Percentages are used in pie charts and units as used in column charts. SPSS allows you to create a "template" and apply it to other graphs that you make or have already made. There are a number of versions available, so you can see which works best for your needs. How to Build an iPhone App from Scratch for Non-Technical People: Your quick and dirty guide; Excel Formulas: 10 Formulas That Helped Me Keep My Job. [source file] A simple bar graph using a separate color per datum. The layer coord_flip() will flip the x- and y-axes creating a horizontal bar graph, instead of vertical. The advantage of creating these cool info graphics in PowerPoint is – you can use the unique tools of the software to add sheen, shadow or reflection to your chart graphics: Source: Percentage Composition – Data-Driven Graph Templates. I am pretty new to Webi, and I am trying to create a Vertical stacked bar and line chart. The line where we create plot using the figure function is where a lot of the magic happens. The Bar/Line Chart component enables you to display one or more series of data on a chart. Change the Default Graph. Then add a title to the graph. Histogram – Use this tool to summarize data using a histogram graph. Creating Charts and Graphs 6 Figure 11. The wizard offers column, line, pie, bar, and area charts. You can do this with a pivot table and. Excel Bar Chart and Line Graph Combined Excel Bar Chart with Line Image Titled Make A Graph In. It is not easy to create this visual appeal by using chart functions in Excel alone. What percentage does a circle graph add up to? and join them up with a straight or curve line Bar graph- Drawn using bars Pie graph- circle of 360 degrees and divide each section measured. You can use bars, lines, or a combination of the two to visualize your data. In most cases, the line will be the median of all the data points that are on the chart. 8) Edit 1 : It is kind of this pareto but with stacked bar :. A bar graph shows comparisons among discrete categories. Unfortunately, I am neither a programmer (per se) nor am I a math major, so I am looking for help on how to enhanced my current formula to come up with a percentage instead of a number. It is not possible to add a calculated series based upon another calculated series. [source file] The same graph but using patterns rather than solid colors. After students understand the components of a bar graph I can have them create their own. How to Add a Second Y Axis to a Graph in Microsoft Excel. You can COMBINE these two chart formats into one chart. But I can't figure out a way to only show just the renewal line without also limiting the bar graph to only renewals. I like how they displayed the variances between years, and decided to recreate it in Excel. A line graph is a bar graph with the tops of the bars represented by points joined by lines (the rest of the bar is suppressed). com you can design and share your own charts online and for free. Out of them, 25 students like Basketball, 30 students like Volleyball, and 20 students like Badminton. Keywords: Stacked Bar Chart, Data Labels. Or, a bar graph might show how ice cream sales differ over the four seasons. Colin Cameron, Dept. However, when you do an experiment, many little things go wrong, and these little things add up. the main difference with line charts is that the horizontal axis is an equally spaced category axis. For stacked bar charts, Excel 2010 allows you to add data labels only to the individual components of the stacked bar chart. 8 (which is technically 80 percent). Bar graphs are used to show relationships between different data series that are independent of each other. Bar graphs convert the information in a chart into separate bars or columns. The blog is a collection of script examples with example data and output plots. Bar graphs display data in a way that is similar to line graphs. A bar graph is a two- or three-dimensional representation of data from the simplest to the most complex. Encourage your students to use range, mean, median, mode, and outlier when they describe data sets. This page aims to describe the customization you can apply to the 3 main parts: the stem, the markers and the baseline. Draw a line graph of the cumulative percentages. In the data set painters, the bar graph of the School variable is a collection of vertical bars showing the number of painters in each school. In my science class we used graph paper to chart the progess of our experiments. Overview: This step-by-step guide will show you how to add target values to your excel charts. It might also help you decide whether Illustrator is the right tool for this kind of assignment. The simplest plot uses all the defaults: graph twoway line le_wmale le_bmale year. Pie charts are best for comparing the parts of a whole.