Chartjs Stacked Bar 100

As the name implies, the 100% stacked bar or column chart uses the percent unit for the y-axis. A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring. Hi all, I have a requirement to create a 100% stack bar with the individual stakcs showing the actual data values instead of % contribution. Angular 100% stacked bar chart displays multiple series of data as stacked bars, ensuring that the cumulative proportion of each stacked element always totals 100%. See more examples. In a 100% stacked bar chart, the bars are split into colored bar segments placed on top of each other. This example shows how Kendo UI Bar Charts component supports a 100% stacked bar. So assuming all that made sense, I want to make a 100% stacked bar chart, that shows the %'s of value by Product. 100% Stacked Bar Chart. Populate the spreadsheet with the data for which you want to create a stacked bar chart. To use 100% stacking bar series, we need to inject StackingBarSeries module using Chart. Stacked Bar Chart. It's been developed since 2003 with one main idea - it should be easy for any developer to integrate beautiful charts into any mobile, desktop or web product. Line; Stacked Line;. I want to see the relative split of sales by month by the different categories, but when I try using the 'frequency percent' aggregated measure in SAS VA, it simply looks for the percentage of the overall total over the 6 months. Hence, the y-axis will always be rendered with the range 0-100. If a stacked bar chart with all labels visible at all time and labels not overlapping is all that you want, there is of course also a solution for that in Tableau. - y-takey/chartjs-plugin-stacked100. When Are 100% Stacked Bar Graphs Useful? by Stephen Few. In a 100% stacked bar chart, the bars are split into colored bar segments placed on top of each other. Adjust Bar Width Adjust MultiSeries-Bar Width. Ask Question Asked 3 years, 2 months ago. So, the height of each bar is determined by the total of all the series values for the category. I found some topics in the community regarding this question: 100% Stacked bar chart in Qlik Sense | Qlik Community. Customize Your Chart. Create 100% Stacked Charts. Now this tutorial is talking about creating a stacked bar/column chart in Excel. 0 and its various chart types. Despite SkyDrive's protests, the file does not contain any links or picture objects. Prism 6 lets you make that graph in two ways. Hi, I'm trying to create a bar chart visualization with 100% stacked bars combined with a line for the goal for my data. Line chart with Chart JS. Bar charts can be configured into stacked bar charts by changing the settings on the X and Y axes to enable stacking. As shown in the below. I want to see the relative split of sales by month by the different categories, but when I try using the 'frequency percent' aggregated measure in SAS VA, it simply looks for the percentage of the overall total over the 6 months. Stacked Column; 100% Stacked Bar; 100% Column. Most articles don't make a difference between stacked column charts and stacked bar charts, so I'll mention them here even if they just talk about stacked bar charts. Regretfully, it doesn't seem to be working in my specific situation. Make timelines, charts, maps for presentations, documents, or the web. The sorting can still be done on sum([Sales]) for each Sub-category, resulting in the same sorting as in the stacked bars. Create 100% Stacked Charts. When Are 100% Stacked Bar Graphs Useful? by Stephen Few. This sample demonstrates how to render 100% stacked bar series using Syncfusion ASP. For example, a company may use 100% stacked column chart to display what product lines contributed to its revenue by calendar quarter. 5 stacked area with objects as data points. The author simply seems to have fallen victim to a common misunderstanding of their real purpose. Simple Stacked Bar Graphs place each value for the segment after the previous one. Open your spreadsheet program. First, click on the 100% Stacked Bar Chart under the Visualization section. A 100% stacked column chart is an Excel chart type meant to show the relative percentage of multiple data series in stacked columns, where the total (cumulative) of stacked columns always equals 100%. D3 helps you bring data to life using HTML, SVG, and CSS. 6 horizontal bar chart with objects as data points. 100% Stacked Bar Chart allows you to compare multiple measures through bars stacked one after the other horizontally. Parts of whole data are often plotted as pie charts, but Prism lets you show it as a stack if you want (horizontal or vertical). This sample demonstrates how to render 100% stacked bar series using Syncfusion ASP. 100% Stacked Bar Chart overview and examples. After reading the first four tutorials, you should now be able to customize the tooltips and labels , change the fonts, and create different chart types. 1 2) foodmart database of postgresql. Whereas the regular stacked bar chart allows you to make accurate comparisons of overall sales and one region at a time, a 100% stacked bar chart will allow you to accurately compare the two outer regions, as we can see below. 3 stacked vertical bar. Does anyone have a fix for this or does it require intensive quality control each time one of these is generated?. By default, this will create charts with vertical bars. Kendo UI 100% Stacked and Grouped Bar Chart Example R1 2019 Release is here. Stacked Bar Chart. A wonderful serenity has taken possession of my entire soul, like these sweet mornings of spring. 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. With plugins you get pie charts, stacked charts and more. Create a Stacked Bar Chart in Tableau Approach 1. Meaning one bar will be Product A, and the %'s I want are of the Subproducts. Line Charts. exceldashboardtemplates. Simple Stacked Bar Graphs place each value for the segment after the previous one. Prism 6 lets you make that graph in two ways. Bar 2D Bar 3D Cylinder 3D Multi-Series 2D Multi-Series 3D Stacked 2D Stacked 3D Stacked Cylinder 3D Stacked 2D w/ Connecting Line Stacked Multi-Series 100% 2D 100% 3D Negative Value. Complete Charts Simple Line Scatter / Bubble Stacked / Stream / Expanded Area Discrete Bar Grouped / Stacked Multi-Bar Horizontal Grouped Bar Line …. 100% Stacked Bar Chart. Even in your illustration, year 2012 adds up only to 99%. I want customization in it. Active 1 year, 8 months ago. js is a JavaScript library for manipulating documents based on data. You can eyeball it, but that's not very accurate. D3 helps you bring data to life using HTML, SVG, and CSS. Bar Charts (Report Builder and SSRS) 03/03/2017; 4 minutes to read +1; In this article. Charts / Bar. Create a stacked bar chart that adds up to 100%. As the name implies, the 100% stacked bar or column chart uses the percent unit for the y-axis. Stacked bar charts allow users to see changes in a series of data and where they occurred. Angular 100% stacked bar chart displays multiple series of data as stacked bars, ensuring that the cumulative proportion of each stacked element always totals 100%. « chartjs-plugin-datalabels. D3 helps you bring data to life using HTML, SVG, and CSS. Hence, the y-axis will always be rendered with the range 0-100. Simple Stacked Bar Graphs place each value for the segment after the previous one. Following is an example of a 100% stacked bar chart. So, the height of each bar is determined by the total of all the series values for the category. By default, this will create charts with vertical bars. Select the data that you will use to create a combined clustered and stacked bar chart. Create high-quality charts, infographics, and business visualizations for free in seconds. A 100% stacked bar chart made in the MS Dynamics CRM chart editor. It's been developed since 2003 with one main idea - it should be easy for any developer to integrate beautiful charts into any mobile, desktop or web product. Series values are stacked at arguments included in multiple series. Additionally it supports rectangle selection - such filtering allows to select multiple bars within rectangle area. The sorting can still be done on sum([Sales]) for each Sub-category, resulting in the same sorting as in the stacked bars. NET Core Bar Charts for Kendo UI jQuery-powered Bar Chart control. How to create stacked bar/column chart in Excel? In Excel, the Stacked Bar/Column chart is usually used when the base data including totality. Now this tutorial is talking about creating a stacked bar/column chart in Excel. Stacked Bar Charts in R. After reading the first four tutorials, you should now be able to customize the tooltips and labels , change the fonts, and create different chart types. May 16, 2016 · Chartjs v2. But is that really fair? I'd say that stacked bar charts are undeservingly demonized in his article. A bar chart is a way of showing data as bars. There is an option for 2-D and 3-D, which should be selected as per the needs and requirements of the presentation style. 100% Stack Bar Graphs show the percentage-of-the-whole of each group and are plotted by the percentage of each value to the. Highcharts Demos › Stacked bar. The total value of the bar is all the segment values added together. Bar; var MyComponent = React. Stacked Bar Chart overview and examples. Basic; Grouped; Stacked; Stacked Bars 100; Bar with Negative Values; Custom DataLabels Bar. 100% stacked bar charts. Basic; Column with Data Labels; Stacked Columns; Stacked Columns 100; Column with Rotated Labels; Column with Negative Values; Dynamic Loaded Chart; Distributed Columns; Bar Charts. I want to see the relative split of sales by month by the different categories, but when I try using the 'frequency percent' aggregated measure in SAS VA, it simply looks for the percentage of the overall total over the 6 months. Open your spreadsheet program. GitHub Gist: instantly share code, notes, and snippets. With plugins you get pie charts, stacked charts and more. You can eyeball it, but that's not very accurate. 0: stacked bar chart. js by setting the type key to bar. Stacked Column; 100% Stacked Bar; 100% Column. Interactive. 100% stacked bar charts. Like a pie chart, a 100% stacked bar chart shows a part-to-whole relationship. Create a Stacked Bar Chart in Tableau Approach 1. Demo source. This is a list of 10 working graphs (bar chart, pie chart, line chart, etc. In the Table Calculation dialog box:. So assuming all that made sense, I want to make a 100% stacked bar chart, that shows the %'s of value by Product. For detailed implementation, please take a look at the HTML code tab. Charts / Bar. The sorting can still be done on sum([Sales]) for each Sub-category, resulting in the same sorting as in the stacked bars. As usually is the case, there were thousands of rows of data. Horizontal bar chart with Chart JS. More information on the 100% stacking bar series can be found in this documentation section. Instead, each data layer represents a percentage of the whole and each stack totals at 100%. Line charts. Then we want to create new columns showing how much each tree has grown between data points. 0)では、帯グラフ(100%積み上げ棒グラフ)を描画することはできません。純粋な積み上げ棒グラフはオプションで指定できますが、比率を. To display the label values as percentages. Most articles don't make a difference between stacked column charts and stacked bar charts, so I'll mention them here even if they just talk about stacked bar charts. Kendo UI 100% Stacked and Grouped Bar Chart Example R1 2019 Release is here. (We introduced the simple Column chart in another article in this series, Column Chart for Analysis Services Data. GitHub Gist: instantly share code, notes, and snippets. One of the charts you have on HappyOrNot portal is a mixed chart with stacked bars and line, like this. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. Environment Tableau Desktop Answer. JavaScriptのグラフ描画ライブラリであるChart. The feature of the widget is enabled by setting the stack type to '100%'. Highlight the part-to-whole relationships of categories and compare various groups with this stacked bar graph. Create 100% Stacked Charts. It's been developed since 2003 with one main idea - it should be easy for any developer to integrate beautiful charts into any mobile, desktop or web product. The other dimension besides Manager Level is Gender. But is that really fair? I'd say that stacked bar charts are undeservingly demonized in his article. There is an option for 2-D and 3-D, which should be selected as per the needs and requirements of the presentation style. Hence, the y-axis will always be rendered with the range 0-100. So, the height of each bar is determined by the total of all the series values for the category. Customize Your Chart. To create a 100% stacked column chart, set the stack100Percent attribute. Hey I tried stacked bar charts in my code, and then even. Simple Stacked Bar Graphs place each value for the segment after the previous one. Even in your illustration, year 2012 adds up only to 99%. co Learn how to add percentages and value labels to the data series in an Excel 100% Stacked. You can do this in single chart only. 1 2) foodmart database of postgresql. Drag Date to column shelf. How to create floating column chart (stacked bar chart) on excel while exporting data How to create Stacked 3D Bar Chart & Multi Series 3D Bar Chart with Fusion Chart stacked bar chart in silverlight 5 using MVVM pattern. GitHub Gist: instantly share code, notes, and snippets. Before I procedure with this amazing chart library, I want to be sure that it supports half donuts. Stacked bar charts offer similar complexity to clustered bar charts by adding together component value items within chart bars or areas. It is separating it into different buckets, instead of merging all into a singular bar, and creating a different stack for each segment. It's been developed since 2003 with one main idea - it should be easy for any developer to integrate beautiful charts into any mobile, desktop or web product. D3's emphasis on web standards gives you the full capabilities of modern browsers without tying yourself to a proprietary framework, combining powerful visualization components and a data-driven approach to DOM manipulation. Example: The first bar (04/16) would have A, B, C and D with the appropriate % of space taken in the bar. Despite SkyDrive's protests, the file does not contain any links or picture objects. exceldashboardtemplates. If you do not have a spreadsheet program, check out the link below for a free trial of Microsoft Excel, which has the appropriate functionality to create stacked bar charts. 0)では、帯グラフ(100%積み上げ棒グラフ)を描画することはできません。純粋な積み上げ棒グラフはオプションで指定できますが、比率を. 6 horizontal bar chart with objects as data points. Blue, Red, Yellow are the different applications. Make timelines, charts, maps for presentations, documents, or the web. AnyChart is a lightweight and robust JavaScript charting library with great API, documentation, and enterprise-grade support. Ideal for comparing the total amounts across each group/segmented bar. 100% Stacked Bar Chart. Stacked Bar Chart. Populate the spreadsheet with the data for which you want to create a stacked bar chart. For example, a company may use 100% stacked column chart to display what product lines contributed to its revenue by calendar quarter. Additionally it supports rectangle selection - such filtering allows to select multiple bars within rectangle area. In a 100% stacked bar chart, the bars are split into colored bar segments placed on top of each other. I created a stacked bar chart where the Y-axis is Manager Level and the X-Axis is Headcount #s. Create 100% Stacked Charts. Tableau Create a 100 percent stacked bar chart Alexis Vandame It's NOT your usual Bar Chart (Infographics Create a Percent and Value Labels in a 100 percent Stacked column Chart. As usually is the case, there were thousands of rows of data. To set the plot title, go to the 'General' section under the 'Style' menu and type in the plot title within the textbox provided under 'Title'. Among the types offered, the 100% Stacked Column chart type is certainly popular. Despite SkyDrive's protests, the file does not contain any links or picture objects. However they count same percentage in each country and they have the same high on 100% stacked bar chart. By stacking items and assigning a different color to each item, you can effectively display trends among comparable or related items, or visually emphasize a sum of several indicators. Hi, One can show the data labels on a stacked chart. I found some topics in the community regarding this question: 100% Stacked bar chart in Qlik Sense | Qlik Community. js by setting the type key to bar. More information on the 100% stacking bar series can be found in this documentation section. Populate the spreadsheet with the data for which you want to create a stacked bar chart. Amazon QuickSight offers both regular stacked bar charts and stacked 100 percent bar charts. This sample demonstrates the implementation of Kendo UI 100% stacked and grouped bars in various data visualization-driven web apps. Randomize Data Randomize Data. Following is an example of a 100% stacked bar chart. Whereas the regular stacked bar chart allows you to make accurate comparisons of overall sales and one region at a time, a 100% stacked bar chart will allow you to accurately compare the two outer regions, as we can see below. All code belongs to the poster and no license is enforced. This view displays all the points of its series. Vue 100% stacked bar chart displays multiple series of data as stacked bars, ensuring that the cumulative proportion of each stacked element always totals 100%. These stacked charts are called 100% Stacked Charts. The total value of the bar is all the segment values added together. I want to see the relative split of sales by month by the different categories, but when I try using the 'frequency percent' aggregated measure in SAS VA, it simply looks for the percentage of the overall total over the 6 months. To use these examples, make sure to also include Chart. The y-axis, instead of representing the actual data values, represents the percentage values. For stacked bar charts, Excel 2010 allows you to add data labels only to the individual components of the stacked bar chart. Environment Tableau Desktop Answer. When to Use Stacked Chart in Excel. Radar chart with Chart JS. js to create a stacked bar chart (sometimes called a stacked column chart). Stacked Bar 100% Charts are similar to Stacked Bar Charts, except that their individual height is calculated as a percentage of total sum. But is that really fair? I'd say that stacked bar charts are undeservingly demonized in his article. So if Subproduct Z is 50%, Y is 25% and X is 25%, then I want the Product A bar to be 50% of Z, 25% Y and 25% X. Parts of whole data are often plotted as pie charts, but Prism lets you show it as a stack if you want (horizontal or vertical). Whereas the regular stacked bar chart allows you to make accurate comparisons of overall sales and one region at a time, a 100% stacked bar chart will allow you to accurately compare the two outer regions, as we can see below. This maximum might be set via Measure. Explore whatever fits you best and save for your own use. If you do not have a spreadsheet program, check out the link below for a free trial of Microsoft Excel, which has the appropriate functionality to create stacked bar charts. This allows you to compare individual contribution of data series to the whole in percentage. A Part-to-whole: With the help of the Stacked bar chart in excel, we can clarify the difference from part to whole and we can see what the. Now this tutorial is talking about creating a stacked bar/column chart in Excel. Injecting Module Chart component features are segregated into individual feature-wise modules. D3's emphasis on web standards gives you the full capabilities of modern browsers without tying yourself to a proprietary framework, combining powerful visualization components and a data-driven approach to DOM manipulation. He includes plenty of easy-to-follow examples to drop in to your next project. This view displays all the points of its series. Bug tracker Roadmap (vote for features) About Docs Service status. So, the height of each bar is determined by the total of all the series values for the category. Once you drag them, Bar Chart will be generated as we shown below. 0)では、帯グラフ(100%積み上げ棒グラフ)を描画することはできません。純粋な積み上げ棒グラフはオプションで指定できますが、比率を. Blue, Red, Yellow are the different applications. Adjust Bar Width Adjust MultiSeries-Bar Width. The author simply seems to have fallen victim to a common misunderstanding of their real purpose. Line chart with Chart JS. I created a stacked bar chart where the Y-axis is Manager Level and the X-Axis is Headcount #s. It sounds quite of a hack. 5 stacked area with objects as data points. NET Web Forms Chart control. You can do this in single chart only. Horizontal bar chart with Chart JS. This example shows how Kendo UI Bar Charts component supports a 100% stacked bar. Each bar height is 100%, and the colored bar segments represent the components' relative contributions to the total bar. In order to create a Tableau Stacked Bar Chart First, Drag and Drop Sales from Measures Region to Rows Shelf. Instead, each data layer represents a percentage of the whole and each stack totals at 100%. As the name implies, the 100% stacked bar or column chart uses the percent unit for the y-axis. I can create a 100% stacked bar chart with percentage on the x-axis and years on the y-axis. Refer to image. Doughnut chart with Chart JS. Example: The first bar (04/16) would have A, B, C and D with the appropriate % of space taken in the bar. The problem exhibits in Excel 2011, Excel 2013 and in SkyDrive. Each bar height is 100%, and the colored bar segments represent the components' relative contributions to the total bar. Line; Stacked Line;. Today, I will show you how to create a stacked bar chart that adds up to 100% in Tableau. I soon, however found out that it doesn't have built-in support for 100% height stacked charts, so my charts ended up looking like this. Stacked Bar Chart. Hence, the y-axis will always be rendered with the range 0-100. Injecting Module Chart component features are segregated into individual feature-wise modules. For example, a company may use 100% stacked column chart to display what product lines contributed to its revenue by calendar quarter. I hope this would help some one in saving their(s) time. Is there a straight way or a workaround to implement this requirement?. The 100% stacked bar chart is great to display the relative amounts within a series. Beautiful HTML5 & JS Stacked Bar 100 Charts - Stacked Bar Charts are plotted when multiple Bar Charts with aligned x values are plotted on same axis. You can create bar charts in Chart. After reading the first four tutorials, you should now be able to customize the tooltips and labels , change the fonts, and create different chart types. Normally, when you use a stacked bar chart, you are comparing raw numbers. For stacked bar charts, Excel 2010 allows you to add data labels only to the individual components of the stacked bar chart. Jack Rometty takes you on a tour of Chart. Chart should have the date as the axis-X and the axis-Y should be 0 to 100%. Simple Stacked Bar Graphs place each value for the segment after the previous one. In order to create a Tableau Stacked Bar Chart First, Drag and Drop Sales from Measures Region to Rows Shelf. Regretfully, it doesn't seem to be working in my specific situation. If you do not have a spreadsheet program, check out the link below for a free trial of Microsoft Excel, which has the appropriate functionality to create stacked bar charts. I used you code to obtain a stacked bar chart like the one with the Actual Sales by Product and Quarter, with the SGPLOT code for stacked bar chart with segment and top labels. Injecting Module Chart component features are segregated into individual feature-wise modules. Her preference is rooted in the fact that the stacked bar graph intuitively indicates the part-to-whole nature of the relationship between missed, met, and exceeded goals. Kendo UI 100% Stacked and Grouped Bar Chart Example R1 2019 Release is here. Create Variables. Bar chart with Chart JS. 100% stacked column or bar chart is a good way to display some categories of a whole changing over time. Adjust Bar Width Adjust MultiSeries-Bar Width. 0 and its various chart types. It sounds quite of a hack. js: Pie, Doughnut, and Bubble Charts In the last four tutorials, you have learned a great deal about Chart. Create high-quality charts, infographics, and business visualizations for free in seconds. Step-by-Step tutorial available at: http://www. The feature of the widget is enabled by setting the stack type to '100%'. Amazon QuickSight offers both regular stacked bar charts and stacked 100 percent bar charts. For example, instead of knowing a tree's height at age 10, we want to know how much it's grown between age 5 and age 10, so that can be a bar in our graph. Like a pie chart, a 100% stacked bar chart shows a part-to-whole relationship. Adjust Bar Width Adjust MultiSeries-Bar Width. The chart types do not differ only in format but in behavior. To create a 100% stacked column chart, set the stack100Percent attribute. D3's emphasis on web standards gives you the full capabilities of modern browsers without tying yourself to a proprietary framework, combining powerful visualization components and a data-driven approach to DOM manipulation. Example: The first bar (04/16) would have A, B, C and D with the appropriate % of space taken in the bar. The y-axis, instead of representing the actual data values, represents the percentage values. The Bar width can be adjusted. I found some topics in the community regarding this question: 100% Stacked bar chart in Qlik Sense | Qlik Community. Line; Stacked Line;. As I add years the chart gets taller. Make timelines, charts, maps for presentations, documents, or the web. Create 100% Stacked Bar Chart in Power BI Approach 2. As the name implies, the 100% stacked bar or column chart uses the percent unit for the y-axis. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. I need to render this data as a 100% stacked bar chart using the charting control from asp. The 100% Stacked Bar Chart is available to edit and customize. How to create a stacked bar chart where the total for each bar adds up to 100 percent (%). I hope this would help some one in saving their(s) time. createClass({ render: function() { return tag for creating beautiful graphical plots. When Are 100% Stacked Bar Graphs Useful? by Stephen Few. Hi, One can show the data labels on a stacked chart. Features such as Hints, Mouse Tracking, Mouse Events, Key Tracking, and Events, Zooming, Scrolling, and Crosshairs raise interactivity and user experience in web charting to a new level. Software used to test this example : 1) Jasper Design Studio 6. The Stacked Bar Chart is represented by the StackedBarSeriesView object, which belongs to Bar Series Views. I could prepare my data and find the maximum, then scale all the other values from 0. It's been developed since 2003 with one main idea - it should be easy for any developer to integrate beautiful charts into any mobile, desktop or web product. Hello guys I'm trying to create a 100% stacked bar chart with a (line chart?) on top of it like this 424656 The main data is the columns A,B and C and then the there's the last column which is the average and I want to make it look like a line chart (the one in the orange line). Gauge Chart with Chart JS (YES we can make them as well with minor tweaks!) Bubble chart with Chart JS. I have been asked to pull together 15 questions with 5 responses Strongly Agree to Strongly Disagree as percentages in a 100% Stacked Bar Chart and a total number of respondents at the end of the 100% Stacked Bar Chart. Software used to test this example : 1) Jasper Design Studio 6. Tableau Create a 100 percent stacked bar chart Alexis Vandame It's NOT your usual Bar Chart (Infographics Create a Percent and Value Labels in a 100 percent Stacked column Chart. In the Stacked Bar Chart to 100% example workbook, right-click SUM(Sales) on the Columns shelf in the Primary Setup tab, and then click Add Table Calculation. js: Pie, Doughnut, and Bubble Charts In the last four tutorials, you have learned a great deal about Chart. Split labels on stacked bar chart. Create 100% Stacked Charts. I'll show you how to add clean, easy to read totals to your stacked column and bar charts… The secret to adding totals to your bar charts is simple - include a total line in your original data series! Select the rows and columns you want for your chart and select one of the stacked chart options from the Insert menu:. To create a 100% stacked column chart, set the stack100Percent attribute. Is this possible in Cognos - it is in Excel. I am creating a stacked bar chart with Charts. For the calculated field, I used "Percent of Total" and "Table (down)" but I get 100% for each measure. There is no way she could have used Excel in-built charts as that would have taken her ages to create charts for. To display the label values as percentages. All code belongs to the poster and no license is enforced.