I have a plot that shows the position of a drifting buoy in the ocean. I have created a second series that is just the most recent position of that buoy. Everyday, using VBA, I update the chart 2nd series to point to the location of the new lat and long. For this second series, which is only one point, I have data labels turned on. I replace the data label text with the date and time of that latest position. Here is my problem. I can not find a way to format the date. No matter what I try, it has the format mm/dd/yyyy hh:mm AM/PM. I really just want it to be a 24 hour clock (mm/dd/yy hhmm).
I have tried forcing the format of the variable date_of_latest_pos, I have tried changing the cell format that contains the actual date and time...
I have a spreadsheet with a customers information and various parts we make for them. I need to be able to take this information and incorporate it into a label format. I need something quick and easy as there can be 150 parts per customer
I have two userforms with a label which displays CompetitorID. I want to transfer content (displayvalue) from UF1.label to UF2.Label. I know labels don't have a value property but want to simply know if it can be done as presently I'm getting run time error 380, can't set property value.
VB : HeadEntryForm.lbCompID = Me.lbCompID ' trf selected competitor ID to ID field on HeadEntryForm
I have a userform in Excel and I would like to have a label calculate from the sum of 3 different labels. I have tried a few ways of which none worked.
This is what I currently have. This returns $0.00 in the label value but does not calculate...
Code: Public Sub TotalCACost() If TextBox12.Value > "" Then Label685.Caption = ""
The reason that I have it as a public sub is that I am calling it to Private Sub extBox12_Change() as well as a couple of other textboxes so that when ever TextBox12 or the other textBoxes gets changed, the value will recalculate. The "other textBoxes" change the values of label443, 444, 445, 385, 386, 387 etc..
I created a userform where if a value from cell x is true then the label caption changes to value in cell z. While everything works fine, the label caption does not seem to appear in my userform until i click on the label. Is there anyway that it can appear automatically once the userform opens?
Also example of my code is:
Private Sub EventDateResult_Click () If Range("A5") = "1" Then Me.EventDateResult.Caption = Range("N4") End If End Sub
I have a spreadsheet with rows of data. Presently, there are three pairs of columns. The first column in each pair has a label (E, F, R). The second column represents the number assigned to the label (e.g. 30, 40, 60, 70). The labels may appear in the first column of any of the three pairs. I would like to reorganize the data in three columns, which are headed, E, F, R, with the associated number underneath the heading. I have attached a sample spreadsheet showing the desired results.
trying to update pie charts via vba. This is working fine, but I have a problem with the data labels. The number of categories can change each time the macro / data is run. This is as it will be for different customers that takle different products.
When the data labels are remapped, those with a small percentage end up placed untop of one another. I have already played with grouping these small percentage together into an 'Other' Category which works fine, but I know I will be asked to split this out.
Is it possible to add a condition that states 'DATA LABELS MUST NOT OVERLAP' - or is there some way of working around this to the same effect...
I have a spreadsheet that has about 40 pivot tables that use label filters for filtering HH:MM and "greater than" selection. When I do a refresh, I have to go back and reset the label filters. Is there any way to not have to re-do every label filter after refresh? I have looked at all the settings and didn't see anything in there that looked like it would work. Maybe VBA?
I have one series on my chart set as column type with data value labels. I have another series as line type to create a benchmark line across the chart. The chart is interactive where user can select 1 of 20 units. On some of the units, the labels are overlapping the line type chart and causing a poor display
I'm working for a local authority who have been given a mass of survey data. In this particular task, residents of each small district within our area have been asked their levels of satisfaction with a service, and how important they think that service is. I want to plot these two values against each other using a scatterplot, and label each service.
Excel does not automatically allow this so I used a very good sheet from the forums here: Attach labels with names to the points in a scatter plot. It's the top file, and works well. However, I can't seem to customise it for my own data.
- Excel often freezing when I try to run it - Not all the data being picked up for the chart - Incorrect labels being picked up..........
I am new in Excel. Recently I have to copy a cell data from Pivot table (example value in B1 cell) to new sheet by this week. My problem is this value could move to C1 by next week & so on. I try to use the column label instead of hard coding like cell column name (B1).
I have a bunch of raw sales data, by individual, which I would like to quartile to determine who is performing at which level.
Not all of this data should factor into the Quartile - a T/F "Exclude?" column flags the individuals who should not count in the quartile for any given month.
I then built a pivot like this with the Row Labels nest like such:
Exclude Year Month Agent
What I would like to do is define a formula that will quartile all of the agents where Exlude is False, Year is 2011, and the Month is January. And I would like this work going forward, so manually defining the range each month would not be a fix.
What do you all think? Is there a way to do this? To tell it to only quartile the individuals for each month?
I have plotted a chart through VBA and I am appending some information to certain data labels. This appended part is being turned a different color depending on if a corresponding value is less than or greater than 0.
Code: For i = 1 To cht.SeriesCollection(1).DataLabels.Count If ws.Range("C" & i + 1).Value < 0 Then[code]....
In stepping through the code, I notice that it works until the color switches twice. So for instance, if the first 3 points are below 0, it turns the appended part of the data label red. Then the next point is above 0 and it turns it green. Then the next point is below 0, and at this point it turns the appended part of EVERY data label red (overwriting the previous green one). It keeps going like this until all of the data labels are either red or green, depending on whatever the last value is as it just keeps overwriting.
I think that this is probably rather simple, but the answer is eluding me, I cannot find anything that helps online either. I have a set of data that looks similar to the sample below, however it is quite a bit longer. I would like the 'Effect' as the X axis, with the 'Score' as Y. This basically shows three columns, which is fine. However I would also like to use the 'ID' as the label against each plot point and I'd like each plot point to look the same.
The problem I am having is that to get the labels to show, I am having to add each series manually, which is rather time-consuming. Is there a correct (faster) way of doing this as I think I'm missing something obvious!
I am building automated solutions where graphs source data is based on outcome of formulas. In case of line graphs I use #N/A as result if no data is available or formula results into an error - this way the data point and data label will not be shown in the graph.
However this does not work for bar graphs - with #N/A, #DIV/0, 0 or "" the bar itself is not shown but the data label is shown (as #N/A or 0). How can I set-up my formulas so that if result is 0 or formula is in error that the graph does not display the data label.
Attached excel file shows same data in 2 charts - 1 line chart (=OK) and 1 bar chart (=not ok). The data for chart is pulled from 2 other tabs (week&month) and merged into 1 data source for graphs.
I'm having trouble filtering a large list of 900 names to create mailing labels for anon-profit organization. For years I have been using Microsoft Works to create these labels, however, the people now doing the membership insist on using Excel. I have Office 2013 and am using Excel 2013 on a new Dell PC using Windows 7. I have partially solved the problem but have one hang up.
I got to a point where I could filter out the dates and a couple of other items, but can't seem to get the last two. I was able to get the minimum date (equal to or greater) than 2012 to filter and the (equal to)LIFE (life membership) one and the (equal or greater than) ID# of 9000to filter by changing the cell format in all of those columns of cells to "text" instead of "general", BUT I still can't get it to (be blank) for the M column which houses a "D" or "U" (indicating deceased or uninterested) and an E column which houses an "E" if the person receives the newsletter electronically rather than by mail.
My fieldset up is:
To Year is equal or greater than 2012 Or M Class is equal to LIFE Or ID# is equal or greater than 9000 And M is blank And E is blank
The first three work but the last two do not seem to filter properly.
I have 6 pivot charts within a document. I use a macro associated with a button to refresh the tables and therefore the data displayed on the charts.
However, each time I refresh the data, the 'data label' font size also refreshes. What is particularly odd is that 5 of the charts are pie-graphs, of those 5 graphs, the font size only resets on 4 of them (with the data labels in a single chart staying at my desired font size).
I can manually put the font size back to that which I desire but I'd rather it just didn't change in the first place.
I've had a look to see if there's any noticeable differences between the 5 charts but there's nothing which I can find.
I'd be happy to run a bit of VBA to set the font size as I want it, if there isn't a better solution.