labels

I would like to add a column to show the percentage change from 2017 to 2018. I would like to keep the current 2017 and 2018 data as is, and just add one column to the right if possible. When I just add it beside the pivot table the percentages dont follow when I expand/collapse the row data...

I am getting this message frequently - a rather simple example is Sub newSub() On Error GoTo SRTT J = 3 / 0 End Sub SRTT: Stop End Sub I have even reloaded Office 365 Can any one help, please?

One worksheet is set up to fit 10 labels on a sheet. If you run Worksheet.Printout the output will fit the Avery Labels. Sometime we need 100 labels or more, meaning we need a multi-page print job. I want to send all of the pages as one print job instead of 10. Is there a way to do that? All I...

Hi there, fine folks! I would like to generate labels for an envelope from a table of data. I have the table of data in a worksheet within a workbook formatted to have the six columns of information. This worksheet is called LabelPrep. I formatted a second worksheet called Labels to look like a...

Hello, I have inherited and frankenstein'd a schedule making spreadsheet. It has a mixed chart that has milestones, only, i can't seem to figure out why my milestone list won't populate the chart with the milestone names on the labels. I even copied in the original spreadsheet's chart and...

Hello, i have a book full of item numbers for an ecommerce site. The template requires me to segregate the upload data. I need to Index RAW DATA on sheet10 and place into Sheet4. Step 1 is to find the matching Item# (Key data) and then read across that entire row to find the matching attribute...

Hi all, hope someone can help here. I supply a retail chain with stock and receive data from a sales cube. I want to look at sales for the past 4 weeks and if they are in decline or don't meet a target I would like excel to trigger a 'Visit' so I can go to/contact the store to see whats up. Is...

Hello, I'm trying to change the color of data labels in a pie chart according to the percentage value. e.g. If =< 5%, then Black, If >5%, then White After some research I tried entering a custom format code in the 'Number' category under 'Format Data Labels', but this didn't work...

I am completely new to this and everything I've learned so far has been from this forum so thank you. Just one problem which I have found many answers but still can't solve. I have 2 sheets (Labels, Order Form). The Labels sheet contains the columns Description & Label ID, along with various...

Simple VBA code to draw arrows, lines, textboxes and labels in userform

I am using excel 2016 for mac, and am trying to use the "horizontal (category) axis labels. in charts" But I can't seem to enter any thing into the box for this. Ultimately I want to be able to put data labels that are not the numeric x and y axis values, but cannot find a way to do that...

Hello the code below works to put data labels onto points in a graph. However I would like a named range to replace the msoChartFieldRange .FullSeriesCollection(1).DataLabels.Format _ .TextFrame2.TextRange.InsertChartField _ msoChartFieldRange, "=Al!$A$45:$A$50", 0...

Hi everyone, I'm trying to set up a ring chart, with both labels and values showing up in the correspondive parts. Only now, labels of zero values appear too, messing things up. I have set zero values not to appear in the cells, but it didn't help. (I cannot use NA() since other formulas need...

Hi I have 3 data labels in column chart. I changed the shape of these labels to Oval Callout. if I select one of them to format, then they will be all selected as well. Which is good and understandable. But how can I move them all at same time. Now when I click on one of them then they will all...

I have a chart based on two columns of data - % of total and the actual dollars. I have the chart show the bars as a % of total. However, my data labels point to the actual dollars so these are based on a formula reference to the cells containing that data. This is referencing a pivot table...

Hi everyone, I have pulled together a Pivot Table for associates across several years showing production data by quarter for each. The way this is displayed is by "financial year" and then "quarter". Column labels have associate name (John Smith) & Row labels have FY and Q (FY2015 Q1), with...

Hi, I have a pivot chart with data labels set to the following format: value, percentage Is it possible to create a custom separator using brackets so it looks like this: (value) percentage any help appreciated! Calum

Hi All , I have a Textbox (TextBox1). If i am entering 2 into textbox 1 , then no of 2 textboxes and labels should pop up. i need 12 labels and textboxes fo the same. Thanks in advance

Hey forum! I am currently working on a chart which is showing time if the format hhmmss. I have some values showing no time (00:00:00). Is there any smart way to hide these values from the data labels? Thanks in advance.

Hi All, How many Row Labels Can a Pivottable Show? Pivottable is refusing to pivot a particular field to RowField and PowerPivot reported there are more than 10,000 labels and it cannot display all labels? Thanks to you all.