charts & graphs

Dear all, I have a simple and yet complicated question. I have a bar figure with three years for 13 countries. Here it is: for each of the countries, and for each of the years, I also have another data (growth rate, if you are interested), that I'd like to plot as a point. So, take for example...

Hi! I've been trying to look for a way to "merge" two or more bar charts, with no success over google nor MrExcel. I'm trying to merge two bar charts into one.As said, one image > 1.000 words, here's an image of what i want: https://ibb.co/bBkdDFf Creating 3 series and making a stacked bar...

How do I choose the source for labels and data for a chart in excel? What I want the chart to show is the label on the left to show Item name, then a line to track the sales month over month and the month and the bottom label to show the corresponding month. Also, if possible add another...

Hi All. I have a table of data which I want to represent in a scatter chart. However, I would like to be able to set a flag against each row in the table to specify whether or not the point should actually appear on the chart or not. This way I can decide which are the pertinent data points to...

Hi, I have the following information: X Axis: Product (Tomato, Apple, Orange, etc) Y Axis: Date range (Sept 1-Sept 30, Oct 1-Oct 31, etc) Values: $ made on each product I want to create a simple chart that will update information based on a drop down menu selected on another sheet. For this...

Hello, I don't have much experience with charts in excel and I'm not sure how to build this chart I want with my data set. Below is a sample of the data: <colgroup><col><col><col><col><col></colgroup><tbody> School ID Grade Level Size $ Per Pupil Poverty Level 2010 High School Medium...

Hi, I have a stacked bar chart which is in essence a Gantt chart. I want it to work on multiple projects however for this to happen I need the Minimum values dynamic. I got the below code from another forum yet it keeps producing the following error Run Time Error -2147467259 (80004005)'...

Dear all, Kindly advise, why is it happening that the first two charts here have lost last few "X-asis" labels? In comparison with the other charts, where all the labels are present, and the same formulas and data ranges are used for X-axis...? Also, is there any way to switch the vertical...

I have a line chart that tracks "change per week." Some weeks have negative values, some have positive values. Essentially, I want to specify parameters so that negative values are colored green, values near zero (possibly + or - 100) are orange, and positive values are red. Is there a way to...

Hello! My system Mac OS 10.11.6, Excel 14.7.5. I have problems with data labels in graphs. I didn't find an option of attaching an Excel file here, so I have uploaded the file to the google drive, but it's better to download it to view because google spreadsheets do not show correct formatting...

Hi, all, I'm starting to realize this may not be possible with Excel, but here's what I'm trying to do. Data: https://drive.google.com/open?id=0BzCEqOa7-nG7UFdNRHpUNFNuNE0 What I want is a pair of chart lines comparing the current and future tax receipts and tax rates for these two groups...

Hi, I'm not sure if this is possible but I'm creating a workbook that as over 1,000 sheets and in those sheets I have data that I would like to make into a chart. I was going to use the select all sheets option and use a Master sheet update tab to create the data but the option is grayed out...

I am having a problem with month and year in a chart. As you see, the month/year field is not in the correct order. https://plus.google.com/105279248984438843964/posts/i6qGXPFRHFG This is where the data comes from: https://plus.google.com/105279248984438843964/posts/6brz7dNWw5z The formula...

I have one graph for labor (A19), one graph for benefits (A20), one graph for supplies (A21), etc., all the way through Total (A29). Each graph is a line graph with markers and is on the same tab as the data. My x-axis is fiscal years. My y-axis is unit cost. The x-axis is always C18, E18...

I have a couple of Powerpoint decks, the first few slides of which contains charts created in PPT. Which means, they don't have the underlying data available readily in an Excel. At present what I do is, I go in these presentations individually, open the data for the charts in Excel, copy them...

Hi, Can someone tell me what kind of chart or graph this is & how to make on in excel? I call it a step chart because it is supposed to show the series of steps taken to result in the final value - kind of like the credits & debits in your checkbook that result in your bank balance. The picture...

Hello all and good evening, New to the forums here. I have a problem I was hopeful that someone could possibly help me out. I am currently trying to work on a spreadsheet which takes production rates and capacities from several locations and gathers them into one page to be viewed by...

Is there a way to create a chart that has relative rather than absolute data? I am trying to be able to copy a chart from one worksheet to another and have it automatically pick up data in the new worksheet. At the moment whenever I try to do this the chart will still link back to data in the...

I have the following Data where A,B,and C are Unique Groups with, for example, group A meeting the benchmark in 0% of areas, meeting the threshold in 63% of the areas, and below threshold in 38% of areas. <tbody> Benchmark 0% 50% 22% Threshold 63% 25% 67% Below 38% 25% 11% A B C...

I'm wonder if there is a macro out there or that can be written that changes the values of the existing series of a chart? I have 28 charts and each chart has multiple series in them. I have created dynamic name ranges for all of the series y values and the series x value is the same dynamic...