labels

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.

Guys- i have created a scatter graph and for someof the data labels arent visible? could see the image attached for further details. thanks

I'm working on a rolling 12-month chart, where the X-axis is MMM-YYYY format. The chart will be posted in 4-panel slide. So the x-axis after being scaled down in size will be hard to read. A solution would be to alternate labels between two levels. Month 1 would display just below the x-axis...

Hi all, Using Excel 2016. I have time bucket values in two different fields in the data source. For example 12 - , 6 | 6 -, 10 | etc... I added these fields to the Rows Filed of the Pivot Table (Tablular) The chart looks good, but I would like to remove the day part labels from the Category...

so, my original pivot table's data source HAD book names like "ECID1," ECID2," etc and was on sheet1. now, I'm using an advanced filter to filter these guys out (ie "ECID1", "ECID2," etc being filtered out) from the ORIGINAL source data, then pasting the info on sheet1. as expected, when I...

Hi All, I am encountering a strange problem in excel . I have few graphs for which the labels disappear partially!! When the entire dataset is selected for graph, all labels are getting displayed. However, when i deselect few data to shrink the graph, few labels are getting missed. One common...

Hey dear community, I have userform where user enter data to textbox and results are showing in userform labels, but entered name can have several match data. So instead of textbox i want to use combobox User type few letter and matching names shows on cells Al2, Al3 , AL4 , AL5 .... AL12 and...

I am having this issue with Pivot Charts. I have a bar chart with about 40 series. I want the Data labels Labels options to be Series name and Value, with a line separator. I can't seem to find a way to apply this to all series. When I make the change it only changes the first series and then I...

I cannot understand why the total for the row labels is one in this example: <colgroup><col><col></colgroup><tbody> Row Labels Sum of Churches Ahoskie 1 Aulander Baptist Church 1 Beulah baptist Church 1 Cashie Baptist Church 1 Center Grove Baptist Church 1 Cool Spring Baptist...

I have 2 shapes, stacked (Rectangle 1 and 2). I have these stacked over 2 activeX controls (Labels) so that when I mouse over the group, Rectangle 2 appears/disappears. The labels are both ordered to the back and transparent. I want to take this a step further and also be able to click on...

Is there a formula that I could use in B1 that labels the column "Date" as well as applies a VLOOKUP formula for the whole column? Please forgive this atrocious question. I'm having a hard time figuring out how to word this for clarity... My goal is to have a sheet that automatically populates...

Good day, I want the Macro to filter out values of distance less than 30km and do a Pivot table as well as also doing for the whole data. So that that I will have 2 pivot tables, one for the whole data and the other for less than 30km. Like this: <colgroup><col><col><col><col...

Hi there, I've searched and searched. Found bits and pieces but I'm struggling putting it all together. I have an Excel file where one worksheet contains 14 charts. I need the VBA code to select only 8 (a certain 8) and delete the data labels. I've found how to select only the ones I need but...

Hi all I had a combo clustered/stacked chart that up until mid last week was working fine as far as value labels were concerned. Since then I have had the Office upgrade, and the Labels have busted. Specifically, the chart is filtered to only show 3 months of the year (May/June/July). The...

Hi There, Maybe someone can help. I want to remove prefix/suffix text in text cell like below. situation now: PL_hftyo_BARCODE LABELS change to: BARCODE LABELS it must be variable because the prefix/suffix is not fixed with the same length Regards, Steel010

Does anyone have a Word Template for Dymo 30253 labels for Word? I've created my own and no matter what settings I adjust it won't format correctly, either blows the labels out, squishes them all into one page or won't select the proper size paper for the label (well it will, but only for the...

Hi, I require a VBA code to help me remove blank cells across different column labels to reflect the first non-blank cell in each column across unique row labels. This: Has to end up looking like: Where all the duplicated row labels are removed, with only unique values remaining and the...

Good day. I have a userform with approximately 50 labels each containing a number which is the latest number in a column of numbers (i.e. I have 50 columns and say 365 rows). I have a code that calls another userform which has a graph when you click on any of the 50 labels (see code below)...

Hi I want to draw a chart for the table below. I have 2 charts in one. I created 2 charts with different Axis (one is secondary). So far so good. Then I wanted to delete the axis and right click on each chart and then click on "Add data labels". After adding Data Labels, I thought I do not need...

Hi All I have 3 pivot tables that has the department name in the filter section, team names in the row section and scores in the values section I have created a slicer on the department name. Now here is my problem Each department has different number of teams. What i want to do is when i...