bar chart

  1. J

    Charts - Merging 2 or more, or manually creating each bar

    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...
  2. E

    Double axis bar chart with different minimum values

    Hi All, I'm try to do what's set out in this post, https://www.mrexcel.com/forum/excel-questions/450643-chart-types-2-axis.html#post2225665 EXCEPT I want to set a different minimum value for the two datasets I'm graphing...when I set minimum axis value to 0 on the left axis and to 1,000 on...
  3. T

    Macro to loop through each row and create a 3d stacked bar graph per row

    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...
  4. V

    Plotting horizontal bars over range

    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...
  5. E

    Chart Help - Multi chart type

    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...
  6. S

    Horizontal Average Line on Vertical bar Chart

    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...
  7. C

    Bar Chart where numbers less than 1 treated as negative

    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...
  8. T

    Multiple start and stop times (with overlap) on dates

    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...
  9. L

    Creating bar chart with last year comparison

    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...
  10. M

    Reconfig a Slicer Button to add multiple Cells to Dynamic Pivot Chart for a Bar Chart

    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...
  11. M

    Nested Charts

    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...
  12. F

    Stacked bar graph - heading not aligning

    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?
  13. S

    Excel gant chart for irregular repeated tasks

    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...
  14. B

    Pictograph/Bar Chart One Data Point with Multiple Lines

    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...
  15. J

    How to remove text from chart when value is zero??

    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...
  16. L

    Excel Graph - Bar Chart with 2 Axis

    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...
  17. 3

    Button to color a selected bar in a chart

    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...
  18. K

    Changing color for Stacked bar chart...

    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...
  19. C

    Stacked Bar Chart with Negative and Positive Values

    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...
  20. P

    Stacked Bar Chart Formatting

    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...

Some videos you may like

This Week's Hot Topics

Top