bar

  1. Q

    MS Access - Create a Stacked Chart

    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]...
  2. S

    Bar Chart For Progress

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

    Lookup, Index and match problem with multiple criteria

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

    Index, match and sum formula problem with Multiple Criteria

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

    moving to next cell

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

    How to create an Excel "sliding" bar chart

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

    Check the text secreted by vertical bar with column C

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

    Scroll bar - what comes first

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

    Form Control Scroll Bar jumping to max value

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

    Formula freezing while being inserted

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

    Graphs

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

    bar chart: vary colors by point option

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

    Tracking aluminum quantities

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

    Stacked bar chart help!

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

    A couple of simple questions for a simple user Ha Ha

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

    Combining data in a bar chart?

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

    Combining a clustered and stacked bar chart

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

    Without Window bar

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

    Subroutine Processing Visuals

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

    Missing Formula Bar Functions

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

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top