labels

  1. V

    All the data labels on Scatter graphs are not visible

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

    Display X-Axis Labels on Two Levels to Improve Readability

    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...
  3. goss

    Exclude Row Fields As Labels In Pivot Chart

    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...
  4. D

    Pivot Tables have a Memory/Cache??

    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...
  5. P

    Issue with excel graph labels

    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...
  6. A

    Excel Userform combobox linking

    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...
  7. J

    Pivot Table Data Labels

    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...
  8. N

    Sum in a Pivot Table

    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...
  9. N

    Active X Control and Shape Handling

    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...
  10. J

    Row 1 Labels the Column and creates formula.

    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...
  11. B

    Filtering Pivot Table values with VBA

    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...
  12. G

    VBA - Selecting certain charts and deleting data labels

    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...
  13. B

    Since upgrade, value labels on chart not working properly

    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...
  14. S

    Remove prefix/suffix text with excel/vba

    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
  15. B

    Dymo 2 up labels and Word?

    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...
  16. G

    Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

    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...
  17. R

    Passing arguments to a graphing function

    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)...
  18. L

    secondary scale

    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...
  19. M

    VBA - whats the best way to filter this pivot

    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...
  20. J

    How to get labels at 0, 10, 20, 30 in an excel chart?

    I have a stacked column chart in excel 2013. The x values for the data are the numbers 0 through 30. I would like the x-axis to have labels at 0, 10, 20, 30. When I format the x-axis to specify the interval between labels as 10, the labels show up at 4, 14, 24. Is there a simple way to get the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top