data label problem

  1. T

    Chart Elements - Can't select Data Label

    I have line 9 charts, updated with weekly KPIs on Mondays. I took over this spreadsheet once it was converted to FY. One line of one chart, once the data is updated, creates a new data point but I can not not select Data Label. I can click on it, but it fails to turn on the data label. All...
  2. D

    Missing Chart Data Labels

    Hello, I have a table with some data on the y axis and months on the x axis. It looks something like this (I am unable to publicly share the actual chart or data): A B C D E F G H I J K L M 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Plan 10 15 20 20 20 15 10 10...
  3. J

    Data labels (depending on 3rd variable) of newly added data points do not show

    Hi guys, First post on this forum . I have a table with a list of initiatives - First column: the number of the initiatives - Second: Description of initiative - Third: Type of initiative (3 different types: digital tool, IT change, Process change) - Fourth: Impact score (0-5) - Fifth...
  4. C

    Chart: Display alternative values as Data Labels or Data Callouts

    Below is my excel chart. I would like to add a "data labels" or "data callouts" As you can see the line is displaying the data from Actual X and Y, but I want to display the DEV values on this line. How can do it? Either any setting or macro code will be much appreicated. Thanks for your...
  5. P

    Pivot Chart Data Labeling not displaying for all Categories

    Hi, I am using Excel 2013 and have added a pivot chart and also included the Data Labeling. The data is generated in a different sheet using a SQL connection. As soon as the data has been populated and the chart created, only 1 of the Categories displays the Data Labeling. For instance : I...
  6. B

    Data label positions in a Radar Chart

    Hi I have created a radar chart in Excel that plots three data series, and have added a macro that adds data labels. At the moment the data labels are not well aligned to the data points plotted. Is there a way to align them consistently (e.g. to the right of the points plotted)? I have tried...
  7. A

    Mac Excel 2008 - How to add Data Labels for Scatter Plot coming from 3rd column (Label, X, Y)

    Hello, I'm using Excel 2008 for Mac & cannot figure out how to add a data label to an XY scatter plot that comes from a 3rd, separate column. I have 3 columns of data: (A,B,C) Labels, X values, Y values When I select the Data Source for the Chart, there is a greyed out box for Category X...
  8. E

    Dynamic Data Label Name

    Hi, I have a waterfall chart and would like to put some data labels on it... What I was wondering is if it is possible to have the data labels pointing to a cell? i.e. =E6 The reason for this is that the waterfall chart sometimes crosses from negative to positive and vice versa, so the way I...
  9. J

    Dynamic Bubble Chart - Legend & Data Labelling problem

    Hello all, In my Dynamic Bubble chart, I have used offset formula in Named ranges for relevant criteria, but my Legends don't pick up individual products, I have switch legend on, its just dumped as one. Same problems with data labels. I need to pick up Product names for each Bubble without...

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