bars

Hello, How would I go about making a graph which plots a number of bars (representing ranges) and lines on the same graph as per below: I would like the lines (which represent the 5th and 95th percentiles of the ranges) to intersect the range as shown in the image. Any ideas?

Hello, I'm using excel 2016. Every time I try to do a bar chart, it comes up as thin lines going up and down. Modifying doesn't seem to help. Where are the bars? How can I get the lines to go away and show me the thick bars that I want? Thanks in advance.

I have created a very simple bar chart. The gap between bars is too wide and I want to reduce it. I am aware about using Format Data Series - Gap Width to reduce gap. However it also reduces the width of bars. Is there any option to reduce the gap between bars without altering their...

Hello everyone, Is there something I'm doing wrong with trying to add scroll bars to my userform? As per the title, I'm using VBA for Mac 2011 and I can't seem to get the scroll bars to work. I can only double-click them to get them to move. There aren't even arrows to click on. What the ...

Hi everyone, this is Francis Ogwal, I made a population Pyramid using Conditional formatting Data Bar with City in the middle, Number of Males on the right and females on the left, i want to copy it and paste it into word to write a report but the bars are not being shown unless i link it has...

Hi, I have a set of data that has three colums; a centre identifier, the type of asset it is (each centre will be classified as an asset type and I have 5 different asset types) and the profit it makes. I have seen a chart before where it shows each centre's profit as a bar (so you get a visual...

Hi, I have a chart may have 1 bar, 3 or even 10 bars as it's dynamic so what I need is a macro that has specific settings like size of bars should be specific size that depends on number of bars, i.e. if chart has 3 bars then the size is ---- and if it's one bar then size should be --- and so...

I was messing around with a calendar form and all of the scroll bars in all of my userforms, several different spreadsheets, stopped working. The "sliders" can't be grabbed and moved and the mouse wheel no longer scrolls. It's only in UserForms, the scrolling in spreadsheets works fine. I've...

Hi There, Relatively new to Excel. I am trying to create a table with colour bars. When I highlight the area that I want to be formatted as a table, it simply won't format, or only a few bars will fill with color and the rest won't format at all. How can I format a table with color bars...

HI Guys i have he below data <tbody> Jan Feb Mar 2017 10 11 5 2017 target 5 9 13 2018 14 13 12 2018 Target 10 15 11 2019 7 3 29 2019 target 10 2 8 </tbody> I am trying to create a graph with months on the X axis and then 3 bars showing , which represents each year and inside...

Is there a way to change the colour of Excel/Word icons on the ribbon and quick access bars? Or a download?

Greetings, Can the conditonal formating data bars become permenant ? so when I add new data to these cells they still show the old formating ?

It would be easier to show you an example, but I cannot post attachments... I am trying to create a chart with grouped, floating bars. In my example, I have 4 groups that each have 3 floating bars (some are crossing the x-axis). This is the most difficult chart formatting I have attempted yet...

hi all, first here mi file: http://www.mediafire.com/file/kw8pbf17me0pqbh/Ejemplo%20Analisis%20ABC.xls second: i am follow this sample: https://ingenioempresa.com/analisis-abc/ my dude is: if you see in first graph, the color of the 2 fisrt bars is orange, this is based on 2 fist values, in...

I have a form that has several subforms on it. When I open the form I have to use the scroll bars to scroll up to the top and then over to the left. it never opens up to where you can see the top or far left. how can I get it to open where the user doesn't have to use the bars to see the top...

I have a listing of all my products. One of the columns is called Sales Revenue. The next column is Gross Profit. I want to insert a data bar into the Sales Revenue column, but that value of the bar should reflect the corresponding Gross Profit, and not the Gross Revenue itself. Meaning, as if I...

I have made a budget sheet on excel and I have a few columns per month. Category, Budget, Actual, Remaining. My question pertains to the Budget, Actual, And Remaining sections. Currently I have an Amount X in the budget column that remains constant. In the Actual column I have a formula that...

When I make the ListWidth value equal to the Width value of a combo box I get horizontal scroll bars even though the text in the rows are smaller than the combo box?

Hi - the graphic visual I wish to display is eluding me... Data cols are clustered time stamps & appropriate frequency count; - I can display as req with unclustered timestamps - but only as event "dots", not as individual vertical bars wrt time... all attempts to draw the bars from the...

Good Day I am using a spreadsheet with some tabs that are published as web pages so that we can display them on TV`s as dashboards. In one dashboard we have some targets, I am using the data bars from conditional formatting to gradually color in the cell as we progress. It works great however...