labels

I have a 3 series stacked bar chart and the fourth series is a data label. The data label is a date value that selects values from the date column. The Primary axis is categorized based on 2 values. The secondary axis is Month. The data labels are displayed accurately as per the month except the...

I do have 3 series in a stacked bar chart. The fourth series is a data label displaying the date. I need to display different color for the label based on a column that as Yes or No values; ie., display data labels in red color if it satisfies Y and display in green if it satisfies No. How to...

I have a spreadsheet with 3 columns (C,D,E). In the first column there are general labels. In the second column there are more specific labels. In the third column there is even more specific labels. Column C will have many pairings with D, which will have even more pairings with E. I need a...

Hi All, This is similar to a previous question I asked, but the table I needed to create for the other option was becoming way too large and cumbersome and the lookup number had to be in multiples of 1000. Here is my dilemma... I am creating a label quote system. There are 10 Groups of...

I'm trying to add the same field to row labels and values of my pivot table. I can get each to work alone, however when I combine the code one is overwritten and left out of the other filter. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Sheet1!R1C1:R22C6"...

I have a line graph in Excel on Mac. The size and location of the labels on the axis change based on the width of the characters included. Wider labels get slightly smaller and move up higher. Smaller labels remain larger and stay on the bottom. These are all the same number of characters...

Hello all, Im using the following code to change the caption of labels rivate Sub Label5_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim stCaption As String stCaption = InputBox("Add new caption", , Label5) If stCaption = vbNullString Then Exit Sub Label5 = stCaption...

Hi, I am trying to apply custom data labels to my chart from a series. This is the relevant section of my code. ActiveChart.FullSeriesCollection(2).Select ActiveChart.SetElement (msoElementDataLabelCallout) ActiveChart.FullSeriesCollection(2).DataLabels.Select...

I have this code below that I can not figure out why its given me a this error. lbSL are userform labels that display percentages. Please help. Thx Range("Z1") = WorksheetFunction.Max(100, CDbl(lbSL)) - CDbl(lbSL)

Morning all i have a document that prints labels, the label has a template sheet and then VBA code cycles through data to populate each label and prints, if i print directly to the printer everything is fine and it prints in order. what im wanting to do is print to PDF, i can sort the code to...

Good day all! I have trouble protecting my sheet's data. I would like to lock my sheet but keep the label alterable/unlock. I know how to do it for cells, but for the labels I can not do it.:mad: While clicking on the protect sheet, there is no case for the labels to tick. Thank you in...

I print every week a lot of labels (4 labels into A4) with product offers. The data are included in 5 columns. So I am copying and pasting 4 rows every time into a range of cells to update the labels value. I am trying to make this copy paste more quickly to produce 30 to 40 A4 pages which I...

Hi, I have a range of dynamic data - I have a formula that returns the euro difference between two sets of numbers, however, I can change this to return the percentage difference between the numbers. In short the numbers in my resultant range are either € values or percentage values. I am...

I need to make many Userform Labels and Textboxes.Visible = False Instead of writing it this way… Label56.Visible = False Label57.Visible = False Label58.Visible = False I thought this might work but I get a Compile Error: “Sub or Function Not Defined” What’s missing? Private Sub...

Hi All-- I have a userform that pulls data from 4 different worksheets. I set specific labels to these data values. Each of the 4 worksheets is set up exactly the same, so Range("C:C") on one is the same on another, so I want to use a single module to run the code 4 times. Sounds simple...

Hi All, I've got an Excel Map of the US and the data labels appear in the middle of each state. Is there a way to move the data labels for the smaller states? They seem to be locked in their position. Thanks!

I am thinking of doing something I don't know is possible. I have a bubble chart that is variable in the data it will display. I have data labels on one series to define the components of all the bubbles in the one lane. I would like to make the data label on a click, go back to the data in...

here goes, i have a workbook with 2 sheets( at this stage. ) i would like to enter all the stock detail in the first into nice neat rows ( like excel does), and then have the second sheet formulate the label ( to print for the bins ) with the data from the first sheet in certain order. but...

How can I clear all the labels with a code on userform UserForm_Initialize() instead of wring below codes one by one? Me.Label1.Caption = ("") Thanks

Hey there! I'm looking to migrate one of my 2D map charts into the new(ish) 3D Maps. It's a veeeeery standard territory map of the USA, so I'm using the Region type map. Now, here's the odd part: while you can enable "Map Labels" (main toolbar on the Home ribbon), that only adds the Bing maps...