bar chart

  1. T

    How do I create a varied width stacked 100% bar chart?

    Each event section has varying lengths. In each section, X, Y, and Z can make an appearance. If both X and Z appear in the same event section, they'd share half the height of a column representing that section. This chart, however, takes away all the significance from the timespan of each...
  2. T

    Bar chart - cluster x-axis and show bars for each cluster

    I am trying to create a bar chart with below clusters. Blue = 2020 Orange 2021 The data comes from Excel: Year 0-100.000 100.000-500.000 500.000-1.000.000 >1.000.000 2020 37,13% 40,0% 33,33% 33,33 2021 47,45% 36,41% 29,27% 20,59 So far I have done this: Step 1: Query Editor Step...
  3. E

    Excel change horizontal axis in stacked bar graph

    I have a table and a bar graph with dates and duration of each activity the graph looks good but the time label on horizontal line is wrong. how do i change this? I attached what the graph looks like. I want it to be one hour interval (3:00 AM 4:00 AM 5:00 AM ...) My data table only contain...
  4. B

    Grouped bar chart with secondary axis

    I've gotten the primary axis (the bar chart) to work but how do I add a secondary axis as such so there is a space betweej
  5. B

    Changing color of one bar in chart

    Hi everyone, I am currently working Excel 2016 on Windows. So I managed to create a simple clustered column chart on Excel. I have my x (company name) and y values (revenue). However, I want to be able to highlight the bar of one particular company name so that no matter how I present the data...
  6. ferdaozdemirsonmez

    Multilevel bar chart show 95% confidence interval

    Hi, I have a multilevel bar chart. I need to show confidence intervals from the descriptive statistics. I can do this easily when I have single level. But with multiple levels (2 levels) I couldn't manage it. I don't want to create 6 charts instead of one for this reason. Can someone please...
  7. T

    Advanced stacked bar chart

    Dear all, I'd like a stacked bar chart that is displaying each category in a given color. The colors are given in the file attached. As an example I have added the image below. I would like to have one stacked bar chart (not one above the arrow and one below) with a timeline at the bottom. Is...
  8. 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: Creating 3 series and making a stacked bar...
  9. E

    Double axis bar chart with different minimum values

    Hi All, I'm try to do what's set out in this post, 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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?
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back