bar chart

Hi all, I have created my Do Loop to loop through my excel spreadsheet by row but I am stuck on creating a 3D stacked bar chart for each row, here is sample data Name Salary Bonus Other Chart a 50...

Hi fellow Excel professionals, I searched the Web and the forum, but didn't find the solution for a problem very similar to one regularly and recently discussed. I have to draw dynamic bar chart colored red, amber, or green depending on whether the value crossed the limit. That is an easy part...

Hello, Looking for some help / advice please. I have the below table of data - which i have created into a stacked bar chart to show each band and the equivalent band widths (minimum-maximum). The chart then has a line chart over it to show the average at each band. <tbody> Band Average...

I want to adapt my code to add a horizontal average line to my bar chart. Sub AddDeals() ' ' AddDeals Macro Dim Wkb As Excel.Workbook Dim ws As Sheets Dim k&, s& Set Wkb = ThisWorkbook Set ws = ThisWorkbook.Worksheets ws_count = Wkb.Worksheets.Count...

I am working on an academic manuscript and making a bar chart figure for the article. I'm using risk ratios so numbers greater than 1 are a positive association and numbers less than 1 are a negative association. I know excel will do bars going down for negative numbers, but is it possible to...

I am trying to show the multiple jobs happening on given dates with their start and stop times represented by a bar. I wish to have time (00:00-23:00) on the vertical axis with dates along the horizontal axis. Each date would have multiple "jobs" occurring that day with potential for overlap. It...

Hi, I am working on an employee survey analysis. I would like to prepare a bar chart with the following information: EXAMPLE - Question: I feel motivated to work for the company. - Result score 2017: 4,5 - Score difference vs. 2016: +1 I know how to create a simple bar chart with a question...

Hello folks, You all were very helpful before, so I wanted to take the time to ask the group how to best tackle a project I am dealing with. I am trying to get a dashboard working with Slicers on it. Not a big deal really but I am having trouble configuring it properly with stacked columns...

Hi, I am trying to creat a graph that is nested in a parent child relationship. For example I have some data the lists production scrap and a value by month. There is also additional area that breaks the scrap value down by reason code, and these reason codes are then broken down by production...

Hi all, i tried to create a Gantt chart but I have an issue with the lables/headings not lining up. Could someone help me align the left hand headings?

Hi All, I need to create a Gantt chart that shows how long it is taking to approve construction drawings. I have attached a schedule of the drawings in question with each one having its own reference number and a issue and review date for each revision. I need the Gantt chart to show the time...

Greetings, I am trying to make a pictograph from an Excel bar chart and have run into a problem with unit "overflows" (units above the max axis) going into a new line. This is pretty rare with normal bars charts, but is fairly typical with pictographs (see image below). Is there anyway to do...

Hallo everybody, My question relates to a simple bar-chart, where I have values from the past week’s sales performance for all our products. Ex: <tbody> Week 45 Sales Banana 5 Apple 0 Orange 10 </tbody> How can I make the text disappear when the value is zero – and make the chart...

I am having a problem getting a bar chart with two axis to render correctly. I have no problem getting the chart correctly rendered as a column chart. Please see the spreadsheet below: Excel File: https://www.dropbox.com/s/p0app4jk6q77ohs/Example.xlsx?dl=0 My goal is for the horizontal bar...

Hi everyone I'm new user of this awesome forum. Basically, I got a bar chart, and I want to be able to select 1 individual bar and with a click on a button, that selected bar change to color RED or any other attributes (3D, shadow, etc). Is that possible with VBA ? :eeek: Please help me...

I have 4 columns Data with the following data Category, Description, Start Date, Duration (in days) ABC ABC - Test1 3/1/2016 80 DEF DEF - Test2 1/1/2014 1117 GHI GHI - Test3 2/5/2015 500 JKL JKL - Test4 8/1/2020 400...

Hi Everyone, I am working on a business case where I am trying to analyze the impacts of several different scenarios. I'm plotting the impacts in a bar chart, like the one in the screenshot below. Intuitively you can probably see, but the blue represents the base case, the orange represents...

I was wondering if there is a way to make a Stacked Bar Chart automatically order the segments within each bar as data is added. For example, I am working on a personal finance project where my stacked bar chart has a category (x-axis label) titled "Food" and subcategories "Restaurants" and...

Hi All, Please see data below. <colgroup><col><col><col><col><col><col></colgroup><tbody> Employee # Employee Name Designation Senior/Junior Allocation Start Date Allocation End Date 123 ABC Engineer J 1-Apr-14 456 DEF Engineer J 1-Apr-14 789 GHI Manager J 1-Apr-14 112 JKL manager...

I have a bar-chart that represents hours by month for a 12 month period. On a secondary axis, I display an FTE count to represent the number of full-time-equivalent people those hours represent. For example, the month of January has 878 hours, which equates to 4.9 people (equivalent) assuming a...