So I have a bar chart with numbers as its data labels...so each bar is divided into 4 colors equaling to 100% ...how can i show percentages next to numbers in the chart...so for example if a bar equals to 200 and each color is lets say 20, 60, 40, 80 ...i would like to show these numbers as well as percentages..i know we can do this manually by inserting a text box but the percentages might change quite often and i dont want to go through the hassle of calculating and changing them each time.
I want to show values entered with percentage sign.(%) Right now, if i enter any value say,10 in a cell having percentage format, shows 1000%. For that, I don't want to enter 0.1. I just want to enter any value and see it with percentage symbol.
When I open a new excel workbook and enter a number in any cell it formats it as though I am entering a percentage. So when I enter 100, the cell value becomes 1. How do i change this? I have tried formatting the cells and no change....
I wish to write an "IF" formular to express a row of numbers in the way I wish to display them in accumulative fashion. 1 upto and including 9 = 1% ...
I have a page for data entry that I want to automatically convert any data that is a percentage to a whole number (50% to 50 - not to 0.50). I am in the Sheet code (not the workbook) and I can't seem to get this to work. Data will likely be pasted by the user in bulk to a range (B3:H32) though data may not cover the entire range. I want the conversion to happen seamlessly to the user as my userbase will exceed 1,000 users, many of whom are not Excel savvy. When I enter data as a percent in the range on the sheet (using B column only at the moment for testing), nothing happens. Right now, the loop only covers the B column, but ideally, it will cover the entire range.
Code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("B3:H32")) Is Nothing Then For Each c In Range("B3:B32")
I've been working on this chart for a while and can't seem to get my x and y axis as well as my series corrected. I have time and distance but since my distances are small I cant seem to make sense on how best to depict my data. Right now it is shown as data points but would love to show value.
I have created a line chart that plots weight of a person, but want to show on the plot area what a certain range of weight represent, Ive attached images to show this concept.
I go to charts and select pie chart and get a graphic illustration of the split.
I'm not sure how I label the different colours?
I want to show that purple = Yes and red = No. I also would like to be able to display the values 200 and 300 on the chart (as happens when you drag the mouse over).
I have some excel sheets that are formatted like the following:
COMPANY | TOTAL | R | G | B company1 | 10 | 255 | 000 | 000 company2 | 20 | 000 | 255 | 000 company3 | 30 | 000 | 000 | 255 ... and so on...
My question is that I would like to have a macro that runs on this basic file and creates a bar graph with the data. Then it utilizes the RGB values in the columns to change the specific bar for that row. So setting the r, g, b as variables corresponding to the columns in the sheet. Also there isn't a preset number of rows in the files.
When i add a month coloumn,Sparklines and Average coloumn should get updated automaticaly.Now this is not happening even if the data is in table format.I also want the graphs to be automaticaly updated.
I am trying to show the all possible combinations of a set of numbers in Excel, in my case I think permutations are more appropriate to use. For example: there are three numbers 1, 2, 3 I want to show results like:
1, 2, 3 1, 3, 2 2, 1, 3 2, 3, 1 3, 2, 1 3, 1, 2
The functions in Excel available only give the total number, but I want to see these combinations!
I want to have a cell report the sum of a column and have that sum change depending on which values I have filtered on another column. I have a cell reporting a sum of times in column E, but if I filter Column F to show only jobs for 1/16/09, I want that number to display the total time for just those shown. At this point, it just shows the total regardless of what is filtered.
I need a formula to show the numbers as they are when they are below 30, but when they go above 30 I need it to display 30 every time. I have attched a file.
I have a number format that I need assistance with:
The number format I need is 1234-000 or 1234-001
The normal number format is 1234-000, very rarely does the 1234-001 be used. So I would like the number format to left fill the left section 1234 and right fill the right section 001.
The current method I'm using to get the results I need in Excel are a bit manual and excessive. is a simple all in one formula for what I'm trying to do,
The data is 3 rows. We can also assume the data is in the first three columns starting from A1.
698 885 499
As you can see in the above set from 0 through 9, the numbers that are not listed are 0,1,2,3,7 And As you can see the numbers that are listed are 4,5,6,8,9.
How do I find and show which numbers from 0 - 9 are not in the set. How do I show the number that are listed in the set Example: Note: the special characters aren't needed.
698 4,5,6,8,9 --- 0,1,2,3,7 885 499
Note the the evaluation is for every three rows. So the three rows in the example are from a table with 150 rows. Each row begins a new evaluation for the next three.....Example:
698 and the following two starts the next set 885 and the following two starts the next set 499 and the following two starts the next set and so on ......
you can see we've hit a problem with the Calendar Control object.
I submitted a workbook which has an Activex calendar control embedded on a User Form. On my PC everything appears as you'd expect, with the calendar showing the individual days in the calendar matrix. However when the user loads the form on their system, although they see the calendar as you'd expect, and they can change the month & year at the top of the calendar, they don't see the individual day numbers, 1,2,3 etc. within the body of the calendar.
if i had a group of numbers , for example, the scores would be 30, 40 , 50 , 60 , 70 and 80 , how would i group that. like it would show me how many scores are between 30 and 50 , it would show up as 3 , then between , 51 and 60 it would show 1
I am trying to put some charts into a report that is pivot table based. I have some code that will work if the pivot tables stay stagnic but the users may change the tables around so that could be an issue of new data. I have the following code where I changed the source to the pivot table name (general name because of numberous report possibilites). I have taken out the other charts because they are just a variation of the chart 1. I am crashing on the line with the * on it.
Sub UWTierChart() Dim oCell As Range Dim oChart As Chart Set ws_data = ActiveSheet 'Chart 1 Sheets(wsPT).Select Range("B21").Select
I have a linked document, only 2 sheets. On the first sheet there is a column for + or - signs, I need a formula for the second sheet to show the + as a 6 and the - as a 5 instead of just the symbols carrying over.
Lets say cells A1 to A5 contain these lines of information:
Till 174 (T0215) - till keeps turning itself off. Till 245 - stuck on windows screen 116 - keyboard is unresponsive Berkel Scale is constantly beeping ped not reading cards Till 156
How can I show only the numbers from these cells (i.e. B1 will be 174, B2 will be 245 etc...)? As you can see the number isn't always in the same place, and doesnt always have the same characters either side.
There are several hundred rows in each column that all need individual ranks. My first thought is to program a if then else statement for 1 to 10 with a % limit range, but this isnt feasable as i would have to program a separate if statement for each of the many hundred rows, or do one heck of a fancy loop that i just cant contemplate (as the rows are split and sepperated... no solid uniform place for the data to be plugged.) What is the best way to go about this? I'm at a total loss of ideas with my knowledge of excel.