labels

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

Hello, I am trying to build treemap graphs for a presentation that will be in PowerPoint. I know that I am not using the chart function exactly as planned but am hoping someone can help. I have created the following treemap, but am having issues with double labels showing up on the graph. Here...

Dear all, Kindly advise, why is it happening that the first two charts here have lost last few "X-asis" labels? In comparison with the other charts, where all the labels are present, and the same formulas and data ranges are used for X-axis...? Also, is there any way to switch the vertical...

Hi Everyone, I am trying to export charts from Excel to PowerPoint using VBA. I have run into an issue where long category labels fail to wrap when I export the chart. This yields a result where the axis labels take up as much space as the plot area of the chart does which is not ideal. I can...

MS Excel 2007 and MS Word 2007. I have created an address data base in Excel containing headers like:A1 name;A2 Door No; A3 Street; A4 City; A5 Postal code; and A6 State. Then address data entered from A2 onwards. I am able to create mailing address labels through MS Word using Mailings...

Good Day, I have a combobox populated with months. My question is if I select any month the labels on userfom will be changed base on combobox text value. If combo shows January, Label1 will fill up with 1st day of January like "Mo" so all labels will show me the days for entire month. Thanks

Hello, So I'm a pretty avid excel user and have all types of cool little tricks and tips i've done over the years with my data... Today, i'm not able to figure this out.. and maybe there isn't a solution (as i've googled and googled and googled). I have a chart that has 5 series tied to it...

Hi When I insert anything under Row or Column in pivot table, excel will add a filter for that Row or Column i.e Row Labels and Column Labels? I can delete the content of these cell (Row Labels and Column labels) but how can I get rid of the Filter drop down arrow? Thank you.

I have a bunch of data, one of the column is received date on the following format. mm/dd/yyy hh:mm Now when I insert a pivot I am having the following. What do I need to do to group this by date only and do not consider the time? <colgroup><col></colgroup><tbody> Row Labels 2/9/2018...

Hello, How do you move labels on a radar chart? I have 45 "Pie" slices that have a description for each and they are illegible at twelve and six o'clock positions. The labels overlap each other. Is there a way to separate the labels a bit further or change their axis to be radial instead of...

I'm building a pivot table with quite a few columns. By default excel puts a column subtotal and doesn't repeat the row labels. I can remove the subtotals and make the labels repeat from the field menu. I wondered if there was somewhere no subtotals and repeat labels could be set as the default?

<tbody> I have a clustered column chart with volume and %change data. I want the %change labels to always be just above the x-axes, even if they are negative. The %change is on the secondary axes. </tbody>

Hello, I'm looking for some help. I want to print 50 sheets where each sheet has 3 labels that look like this (The right side is a copy): <tbody> Title Title LABEL# (M1, M2, M3...M150) LABEL# (M1, M2, M3...M150) Date Date Shift (Day / Night) Shift (Day / Night) Number Number...

Hi All, Having a little trouble, trying to create a line chart based on dates and sum. I've created a pivot chart to group all the same dates and sum them together per person. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Sum of Amount Column Labels Row Labels Q...

Hello, I'm looking for some help. I want to print 50 sheets. Each sheet should have 3 labels that look like this (The right side is a duplicate / copy): <tbody> Title Title LABEL# (M1, M2, M3...M150) LABEL# (M1, M2, M3...M150) Date Date Shift (Day / Night) Shift (Day /...

I'm trying to attach labels to data points in my xy scatter chart. The label data (names) is in column C, the X and Y values in respectively column D and E. I've researched for solutions, found a macro and included it. So far, so good. Whilst the macro does attach (name) labels to the data...

I'm using Excel 2003, and I'm trying to go from address labels to a single line per household. I have nearly 10,000 lines to go through. Is there any way of doing it faster than copy/paste/delete ad nauseum. The original one looks like this |Jane Doe |123 Any Street and I need it to be: Jane...

I have created an Excel database for my address labels, and then created the labels ready to print in Avery Labels's excellent Design and Print software. I thought that I could alter the fonts, colours etc, in one go after creating an Excel database, but having viewed the options in Design and...

Hi there. I have put a file on the following link: https://www.dropbox.com/s/icu4rtgoy6oy3bw/Scatter%20Charts%20problem.xlsm?dl=0 I hope this is ok, as we are not able to post attachments. I am having some problems with some labels appearing on the scatter charts. If you look at the file on...

Thank you in advance. I've created an order system in EXCEL/VBA - we have a worsheet 'clients' (demographic info - pricing levels - sales tax etc) When we create an order for a client - we also create/populate LABEL data within the worksheet 'printlabels' (IE 4x6 thermal labels to be placed...