bar chart

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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?
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top