data labels

  1. H

    formatting of data series labels and lines (line chart) is lost, when I slice data

    I was trying to improve the look of my combo chart, which has columns for one series and lines for 3 other series of data. I did a great job of getting it into tip top shape so that data labels were called out above the lines, the lines color coded, the numbers were black....I made sure to Save...
  2. B

    Excel Pivot-chart data-labels formatting issues

    In Excel 2010, I'm using several pivot charts to display several types of data. They are all basic column charts with the data labels at the top of the column. I want all of the data labels to be rotated 270 degrees (right click data labels > format data labels > alignment > text direction >...
  3. P

    0% and No Value in charts

    i have a table which has values coming out of formulae e.g. A - 25.00% B - 0.00% D - #N/A E - No Value <tbody> serier formula calculated_value data1 data2 a =IFERROR(IF(F5="","",F5/G5),NA()) 25.00% <tbody> 1 </tbody> <tbody> 4 </tbody> b =IFERROR(IF(F6="","",F6/G6),NA())...
  4. G

    Scatter XY Plot & Macro Help needed - adding/removing data labels

    I have an XY Scatter plot chart in Excel in which the X-axis represents sales dollars and the Y-axis represents profit margin. I have several thousand data points, but I need to be able to only look at sub-sets of this data which I have by adding a filter to my data in a different tab in Excel...
  5. D

    Area Chart Data Label

    I have a 100% Stacked Area Chart in Excel and I would like to label each area instead of using a legend. When I turn on the Data Labels it defaults to show the values and when I go to "More Data Label Options..." and select "Series Name" it only applies to one Series at a time. I would also like...
  6. A

    Excel 2010- scattergraphs- data labels

    Help!! I have plotted the age vs number of siblings in a scattergraph. If I then hover over the bottom point, it gives me the value (2,1). Is there any way I can get it to show the name "George" instead? Much appreciated! <tbody> Name Age Number of siblings John 12 4 James 7 2...
  7. TinaP

    show every other data label

    Is it possible to show every other data label as well as the final data label without manually deleting them? I have a chart with a number of data points and when I show all of the data labels, they overwrite each other. It's not necessary to see every one, but I need some data labels at...
  8. P

    Data Labels

    I am getting an error "Unable to get Points property of Series Class" while assigning data labels using code. The code runs correctly for few cases and then suddenly throws an error. " ActiveChart.SeriesCollection(1).Points(counter).HasDataLabel = _ True...
  9. T

    Help with Macro to Change Fonts

    I have a macro that goes through each sheet and changes the worksheet font and the font on any graphs to be Arial. I have data labels on a couple of the graphs and some of them are bolded, italicized, or a different color. When I run the macro, it loses any formatting I had. Does anyone know how...
  10. T

    Macro to Autofit Data Labels on Scatterplot

    Tried searching the forums, but couldn't find anything. I have an XY scatterplot of data with data labels in excel 2010. The problem is that the data lables tend to overlap each other or they'll appear right on the data point and I end up spending excessive amounts of time formatting them...
  11. A

    Data labels only for positive values

    Hi, I am dealing with a lot of charts where I want the data labels to be visible only for the points with a positive values attached to them (otherwise the chart looks very clobbered). Can anyone help me with this? Any solution (VBA or otherwise) will be of great help! Thanks in advance
  12. B

    Stacked column with % in columns but actual value in y-axis

    Excel 2007: I have a stacked column chart with 2 numbers. I want to display the % total in the columns data labels but still have the actual numbers showing as the y-axis. Any way to do this without having to create dummy data & a secondary y-axis? Data example: Hosp Data1 Data 2 A 10 15 B 25...
  13. M

    Tricky (?) data labels position problem

    I want the default position of the data labels of the first series in my BarStacked100 chart to be in the center, i.e.: "DataLabelCenter". However, when the position of centered data labels is more to the left than it would be if I used "DataLabelInsideBase", then i would like like them to be...
  14. B

    Multiple Data Labels on a Pie Chart

    Hello All, So I have a table with 8 rows and 3 columns. This table includes: Column 1 - shipment name Column 2 - shipment cost Column 3 - shipment weight I have created a pie chart from this table, which covers the first two columns. Displayed next to each slice is a label with the...
  15. F

    Format data labels in Excel chart automatically as I add data

    Some background: I have 40 individual data points that I am plotting on a scatter plot in excel. As I add them, I am having to go, each time, and update the format of the data labels. What i need is only a label and no data point or line to appear on the scatter plot. I want it to have a...
  16. L

    Office 2010 - Stacked Column Totals Legend Issue

    I needed to add data labels containing the totals for a stacked column bar graph. I used both the line chart strategy and the x-y chart strategy. Both gave me totals. The problem now is that my legend reveals a third series which I do not want to show up. I do, however, want the other 2 series...
  17. T

    Conditional Format Chart Data Labels

    Hi all, I have a bar chart that feeds off a table that has a drop down option to either show the actual numbers, dollars or percentage. I'd like to have the data labels in the chart change their number format depending on the table format (either general number, $ or %). But I'm stuck- any...
  18. L

    Pivot Chart Data Labels Disappear

    I have a pivot stacked chart with data labels. When the pivot table is updated, the data labels disappear. Any suggestions? (Thanks, in advance, for your help)
  19. T

    Chart- Dynamic Data Labels Multiple events

    Hi, I have a simple line graph created from 2 columns of data: Date (x) and Count (Y). I want to place data labels that will call out an event for a particular day. So for 08-01-10: It could have one or more different data labels of an event for the corresponding (Y)-data. The data...
  20. R

    Last data label with label + text

    Hi, Not sure this can be done, but if anyone can find out it is probably you. :) I have a line graph with the monthly results of a company. I have used an offset-formula for the graph, so that when the users update the dropdown menu in the workbook to the current month the line graph will...

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