bar

  1. E

    Interactive search bar

    Hi guys. I have a large datasheet in which i have tabel 1. This tabel contains 5 coloums and 200 rows. I Would like to insert/create a search bar in which i Can type words and then the search bar should ‘hide’ Rows that does not have any of the five coloum resultat in common with the searched...
  2. R

    Rounding time to nearest previous interval.

    Hello Everyone, I am attempting to rounddown the time to the nearest previous interval. I have some data in excel. It logs the start time of a bar. Eg the 16:00 bar begins at 16:00 and completes at 16:00:59 Now when the time is at 17:20 I would like excel to look for the time 16:00 (starting...
  3. T

    Colored numbers in Formula Bar

    Hello. Im new around here. I wasn't able to answer the question I was looking for by googling, so wondered if I'll find it her. Maybe someone will answer. I'm looking for a way to make in formula bar sum numbers to be colored, like here. I want numbers to have different colors. In example every...
  4. J

    Quick Access Tool Bar Self-Changes

    I am a big fan of the Quick Access Tool bar which I have customized to give easy access to my most commonly used functions. I have them grouped logically. For some reason the icons don't stay put. The icon in one location keeps moving elsewhere on the Tool Bar. Occasionally, another icon...
  5. C

    hourly bar graph

    Need to make a (daily) hourly bar graph for my work schedule. The data part would be the name, starting time, ending time. I work like to select a horizontal bar graph view as in the image to produce this graph...
  6. C

    silly object question, Probably right in my face

    So I have a "Tool Bar" across the top of my worksheet that I want to remain the exact same size and position except when row 1 is hidden the tool bar should be hidden as well. If I hide columns etc I don't want the tool bar to change size but I can only seem to get it to either not size or hide...
  7. C

    Bar Graph (Horizontal) for time

    I want to make a bar graph for a schedule for a work week. Column A: (format: Date) I'll put in the date Column B: (format: Name) I'll insert the Name Column C: (format: Time In) I'll insert the Time started Column D: (format: Time Out) I'll insert the Time started Column E: (formula needed for...
  8. R

    VBA window issue on Mac.

    Hi All I've been using Excel on Mac for many years and never had this issue till now. It's probably more that I don't understand than an issue. I have always been able to double click on sheets in Excel Objects, they would open in a window with a gray title bar and the option to close, min or...
  9. R

    Can I make a horizontal scroll bar inside a userform represent a ratio split?

    Hi all, Let's say I have a counter of two different brands, JG and OM. I have a horizontal scroll bar on a userform which I want to show the split between the brand allocation. If I have 300 allocations, and 200 are JG and 100 are OM, I would like the bar to look as follows...
  10. O

    Why does my Status Bar stop updating.

    I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...
  11. I

    EXCEL chart

    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...
  12. Jaafar Tribak

    Excel 2016 - SDI - Formula Bar

    Hi all, I have just installed office 2016 x64 and I am experimenting for the first time with the new SDI interface with which I am not familiar. Say, you have two workbooks opened, each on its seperate window (same excel process) Now, say you want to hide the formula bar just for one...
  13. T

    Need to create a simple bar chart with rows of data...

    I'm stuck. I have several hundred rows of data with various columns (see example): <tbody> Date Segment Product Sales Rep Region Sales Jan-18 Enterprise Widget 1 Bob MW $500 Feb-19 SMB Widget 3 Cindy NW $250 Jun-18 SMB Widget 3 Suzzie SE $1000 Jan-19 Commercial Widget 2 Bob SW $35...
  14. P

    Restrict Specific cell in specific sheet to manual entries ONLY i.e. NO paste of any kind!

    Can someone please help with constructing a code that will enable me to restrict any form of pasting (ctrl V or right click) in a specific cell. NOTE: This cell is an access signIn area and as a result, the status bar disappears when you click on it (to avoid situations where onlookers can see...
  15. R

    Stacked Bar Chart Comparison

    Sorry, not sure how to word exactly what I'm looking for, and Google has not returned what I need. I have a data set with results from 3 divisions (A,B,C). I'd like to create a bar chart the stacks quarterly results from A and B and displays them next to C. i.e. in Quarter 1 A had $40 million...
  16. G

    Hidden character

    I've inherited a workbook with a bullseye symbol in cell A1. The curious thing is that the formula bar shows nothing in the cell other than a wide space. When I check it with the formula in B1 =CODE(A1), it returns 158. When I enter the formula =CHAR(B1) it returns the character "ž". If I...
  17. L

    hide toolbar, ribbon, formula bar etc

    Hello, Is it possible to hide toolbar, formula bar, ribbon etc.. for only one workbook? link for the workbook : http://s000.tinyupload.com/index.php?file_id=66089730027655191139
  18. M

    Bar Chart - Amending bar colour automatically

    Hi I have set up automated timeline (Gant Style) workbook for colleagues whichworks fine but they have now asked me if I can have the bar colour changeautomatically if a task is past due e.g. Green while it is in scope and redwhen it is Out of Scope. This is not something I have been asked for...
  19. R

    Excel 2k Menu toolbar somehow got detached and is much smaller---help

    My first post here. I know this is an old program--but it does everything I need a spreadsheet to do :) Somehow my Menu bar is all screwed up. With my W7 Pro config, there is a Deep Blue bar at the very top, the menu bar is about 1/3 the width of the screen and is less height than the Formatting...
  20. C

    Wildcard filter and user prompt to search for material number in excel

    Hi there, I need some help in terms of the code I require for prompting the user to key in the material number and using that material number as a wildcard filter to search the excel sheet and copy the values from 2 columns and copy the material numbers that contain the search term and paste...

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