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