bar

I have a bar/column chart on a report which is based on fields from a query. Horizontal axis is the [WeekNumber] field and the Vertical Axis is [StaffName]. This works fine! However, I want to change this into a stacked bar chart with the [StaffName] columns being split into [RecordType]...

Hi there - what I thought maybe simple but I cannot find an answer! I need a bar chart with the various work items along the side, i.e. WORKITEM_1, WORKITEM_2, WORKITEM_3 etc. Along the bottom of the chart I need to have the various stages (these need to be words, and not a percentage of its...

Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down...

I am new to Mr. Excel I look at it often for answers to questions about formulas that I have. Most of the time I can research it out enough to figure out and find a formula that works. I don't like to bother people if I can do it myself. But I just can't figure this out. please help. If I have...

Hi I selected cell A1. I want to go to cell A2. I used the down arrow, but to my surprise, it wont move to A2 but the whole sheet will go down (it is like I am screwing down using the screw bar in the right hand side). Why this situation happened? Thank you very much.

Howdy folks. I'm looking to create a sort of "sliding" bar chart in Excel. This chart will have a "whisker" that extends out to 100% and the bar chart will only fill the appropriate space among the whisker. Could anyone help me recreate this chart in Excel? Thanks much! Marc

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I want to check E5, F5 or G5 text secreted by vertical bar with column C data if find then place result as "OK" in the cells E6:G23</SPAN></SPAN> Example...</SPAN></SPAN> Book1ABCDEFGHI12345P11 | X1 | 2X |...

Can anyone tell me what action comes first with a form control scroll bar- the assigned macro or the action of the scrolling bar moving? if the scroll bar moves before the macro is ran, can you delay the action of the scrolling? or is there a way to have a part of the macro run first? Thank...

I am having an issue with my form control scroll bar. It works just as intended unless a user is entering data in one of the cells. If a user enters data in cells R77:V94 and does not hit enter before hitting the scroll bar, the scroll bar jumps to the max value. Why is this? I can certainly...

I select a cell. I type in a formula in the formula bar. I hit enter. In the cell, rather than a result, I see the text I typed in the formula bar. When I try to delete what's in the cell, the text does not disappear. However, the formula bar shows there is nothing in the cell after I have...

Hi, Can someone please help with this? I have a vertical bar chart with 7 bars. Is there a way to have in the same bar chart this? bar1 and bar2 linked to each other without space. Space. Bar3 and bar4 linked to each other without space. Space. Bar5 and bar6 linked to each other without...

Hi Yesterday, I inserted a bar chart. I right clicked on any bar in that char and then clicked on "Format Data Series" then Click on Fill icon, but could not find []Vary colors by point!! I am not able to reproduce that issue again! My question do you know under which circumstance that option...

Hello, New to this forum and thanking you in advance for any assistance you can offer. This is what I am attempting to do: Me and my husband recently opened a small shop to fabricate aluminum frames. The orders are starting to come in and I am trying to come up with a system that will allow me...

I have data that I'm trying to get into a stacked bar chart, and am having trouble getting it set up right. I have multiple values (A1, A2, B1, B2, C1, C2, etc) across several months. I'd like to stack A1 and A2, B1 and B2, etc, by month. (ex data below) How do I set up the chart in excel to...

Hi, I am wanting to have a one page Sheet so i can print it out on the A4 paper. What i am doing is coloring the cells yellow at present to show my the point at which my preview shows me 1 page of 2 I can then delete that row / column etc and then i have my one page template as such,with me so...

Hi, I'm trying to show total expenses for each person, in a separate category, from a pivot table, as follows: So each bar represents the total spent, while each color represents the category it was spent on. I'm having trouble getting Excel to do this, as it just creates a new bar for each...

hi, I am trying to create a chart that contains both a clustered and a stacked bar chart. The stacked bar chart contains balance sheet data of two segments of a company in 2017. I also have the combined data as at 2018 so I want the 2017 and 2018 data to be a clustered bar chart for comparison...

Dear Friends, Is it possible hide window bar and close button from a userform in excel vba? Please reply me!

I've just finished creating my VBA spreadsheet and while it's very useful and 'a bit of a beast' it's not so impressive to look at while running. I played around with turning screenupdating on and off and either way doesn't make much difference so was just wondering if anyone had any tips on...

Lately I have been experiencing an issue with my formula bar that doesn't appear to have been picked up or questioned anywhere else. Essentially what is happening is that on some spreadsheets the insert function button and cell number/coordinate box are missing and the formula bar extends the...