bars

Hi, I am trying to increase the width of each bar in a bar-line chart. I have found various people saying how to do it and the answer does work to some degree but not enough as my bars are still pretty skinny. How can I make them wider still? The method I have seen an tried is simple...

How can I make an excel 2013 chart with bars that compare one FY to the next FY with the percent difference in a bubble above the two bars. i.e. First number is FY17 (10.00) second is FY18(9.91) (.......added for spacing) The (-8.6) is in a bubble with arrows from 10.00 to 9.91...

Hi All, I want to know how do I make it so that for a set of 2 data bars on a chart, if the corresponding cells have N/A values, then it just won't show up on the bars at all. I am sure its just an if statement but not sure how to implement it, any advice would be well appreciated.

Hi everyone, so I have a bar chart that is date (x-axis) by hours (y-axis), and for each date there are two bars (based on data from Column C and Column D). So I want to make it so that the chart automatically updates everytime I enter a new set of data for column C and D, and everytime the new...

Hi there, I have received a .pdf file, which is an export from an Excel worksheet. What you see is what should be on the Excel worksheet. The meaning of the text is not important, so please ignore the theme, scientific, medical or else. I like the design of presenting the data ( description or...

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

Hi, How can I create a space between the two bars in the pivot table? I am using a secondary axis for the Percent column. Cheers, Tamir

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

Hello All, In Excel, I'm not finding how I maintain a "set" color in a newly added "select data". I don't want excel to Auto Fill, I want all added bars to have the same color, with out manually choosing the color. Thanks excel 2013

Hi, I'm new here (fairly basic Excel skills but trying to improve) so go easy on me! I'm doing a spreadsheet for a gymnastics competition. I have the following data and I want to highlight the top 3: <colgroup><col><col span="2"></colgroup><tbody> Name Bars Score Bars Ranking Holly 8.0 7...

Hello All, Is it possible to maintain the position (and width) of columns in a stacked bar chart after applying a slicer? Developing a Dashboard. I have a table of data including dates presented vertically (say column A). I have positioned a pivot bar chart beside the data. The presentation...

Dear all, I have a recurrent problem when making column/bar charts with error bars and data labels. Whenever I add data labels to the outside end, these labels will always overlap the error bars (please see image). Is there any automatic solution to position the data labels on the outside end...

Hi Everyone, I'm not sure this is possible, but I was wondering if anyone knows a way I could increase and decrease the size of a chart according to the number of data lines I'm using? I have a chart just called "Chart6" (its a horizontal bar chart) it is dynamic and increases and decrease in...

I have created a histogram for data that is collected in unequal intervals (grouped data). I determined the frequencies and used the bar chart. I want to change the widths of some of the bars to different widths. I can find the following -- I click on one of the bars and it shows a width on the...