bar

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

Hi, I need some help with a graph. If you look at the second line of the data (first picture) - you'll see this is captioned as FS&CM. This is plotted along the bottom axis. But from here, I need to combine KSA / UAE / KWT / GCC in one bar (as per the second picture) .... but what I'm...

1. In excel 2013 , can you scan a barcode so that that barcode takes you to n spesific block A1 on a specific sheet. ? 2. In the first sheet i have in colum A serl. no.s , in colum C a bar code no.s and in colum D a Name.In another Sheet i scan items in RANDOM BARCODES , I want the name and...

OK, so, I need to tap some excel wizardry on this. I want everything (menu bar, tools, ribbon, the works) hidden. I only want the cells and maybe a scroll bar to be seen. I linked an image of what I imagine it to look like...

Hello in cell A1 = when typed the following =(300+500)*5/10 i get result as 400 in cell A1 Will it be possible to implement the same in userform Textbox so that when i type the same in the userform textbox =(300+500)*5/100 but the result of value 400 is displayed in Cell A1 and formula also...

I would like create a bar chart in Excel to show the progression that will change color based on the % completed towards goal. I want the progress bar to follow the below color scheme format: <80% = Red Bar >=80% = Green Bar I want this to be one single bar that changes color based...

Hi all, I'd like to know what you all think is best way (specific details not required) to show the status of a given item over time as 3 minute snapshots. A color slot (Yellow, White, Green, Red) will be added to each interface every 3 minutes. Interace_1 YWWWWGGGGGGGGGGGGRRGGGGGGGGYWWWW...

I have a spreadsheet that users need to use to scan in bar codes. When they try to scan the bar code the cell populates with #NAME ? The cell is formatted as General Any thoughts about what is causing this?

As the title indicates I am trying to find a way to copy the first visible email address in a given column to the recipient bar inside of excel. I had no problem setting who the email would be CCd to as it is static. Further I have been able to copy from a cell into another cell in a dynamic...

Here is VBA code which automates the complete 'Save As' file download procedure in IE11, when a download is offered by IE's Download Notification Bar. To use for your own web site downloads you would automate IE and do whatever is necessary to make the Download Notification Bar appear at the...

Hi all, I would like to use a VBA code, so that to run through col “G” and where find bold text should “SUM” the col. “I” less col. “J” in adjacent cell in col."K". Therefore, that the data start from row “7” and are more than 400000. Thank you in advance Original data <!--[if gte mso...

Hi all, I would like to use a VBA code, so that to run through col “G” and where find the text “Opening Balance”, should move the number in adjacent cell from col. “I” to col. “H” Therefore, that the rows are 100000+. I present below the original data and the expected result. Thank you in...

Using Excel 2000</SPAN></SPAN> I got data in the column C (A, B, C, D and E) separated by vertical bar and there is a one space between vertical bar also that I want to coloured all different colour but each alphabet must be the same colour in the below example there are coloured only row 5 & 6...

Hi all, I would like to use a VBA code, so that to run through col “B” and where find the name of each department, e.g. Restaurant, Pool bar e.t.c., should place it in col. “F” and rows down for each department’s records. Therefore, that the rows are 100000+. I present below the original data...

Is it possible to change the legend order in a clustered bar chart? If so how? I cannot use 'Sort by columns' as it is greyed out. I have One column called WeekStatus which is supposed to go on the legend field. Entries for WeekStatus are: Current Week Previous Week The chart shows Current...

Hi I'm creating a waterfall chart in Excel 2016 and would like to know how to do two things, please: 1) to re-set the bars so they all start from zero eg at the moment, I have a bar which has the value 123 ie 123 instances occurred in this particular instance. But it goes from 150 on the...

Hi, On a mileage worksheet in cell C32 i have a value of £23.40 This cell has the formula of =DOLLAR(D31*0.45) so all is ok. I then run a macro which copies this cell data to another sheet. Upon that sheet the columns are added up but i see an issue. In each cell i see this, Using these as...

Hello everyone, Quick question here - I downloaded one of Microsoft's sample project plan templates. As I started tweaking it, I noticed underlying logic seemed to stop working. The cells have a progress bar, so whatever percentage amount you put in the bar in the cell adjust to show.... so...

The font in the formula bar somehow changed to italic and also one size smaller when I press F2 and the font is also showing in grey colour. But this only happen in one of the excel file. When I opened other excel file, the formula bar works perfectly fine and the font size & colour remain...

How can I graph two lines of data into bars that share the same x axis, but different Y axes and are not stacked. The alternate is to make one of them a line graph, but in the case I need them both as independent bar graphs next to each other and referencing different y axes. Thanks in advance...