datalabels

I have an Excel scatterplot with a number of 2-point series. I am trying to set the position of each DataLabel in VBA, but its behavior is unpredictable. Here is the result, with each label text showing the (.Left, .Top) value that was set: I would expect every label with .Left = 100 to be...

I have seen a lot of similar questions but nothing that is quite the same as what I am trying to do. I am trying to modify Data Labels in a chart tab, which was copied from another chart. I already have a macro that changes the data and the chart title but now I want to change data labels of...

I have written this code and and the labels for the charts appear outside the graph area. I want to position data label inside the pie charts. How to do that ? With oChart4 .HasTitle = True .ChartTitle.Text = "On Net/ Off Net (Overall)" .ShowAllFieldButtons = False .ApplyDataLabels...

Hello Mr. Excel, I'm new to the forum and a relative VBA novice. I have automated the production and export to .png file of multiple bubble charts based on a dynamic SharePoint list. These charts can then be lifted into Access to overcome the problem with the dated chart engine. My issue...

Hello, I need to create some quality reports for my work and run into this "strange problem". I create some pivot tables from raw data and then create the charts visualizing each pivot table. Trying to represent with green or red, if the specific platforms we build meet the first pass yield...

Ok so I have this problem and its doing my head in. Basic set up: One one sheet I have a pivot table with bulk data, on another sheet I have 3 XY charts that run off the pivot table. I have one subroutine that manipulates a pivot table based on a comboBox selection. It basically turns on/off...

Hello! I'm trying to use VBA to copy the formatting of the datalabels of a specific data series in a chart, store that format in a variable(s) and then apply it to a different set of data labels. I'm trying to get the info on font color, size, bold, underline, etc. Any ideas on how to read...

Hi, I'm trying to create a XY scatter chart in VBA in an excel sheet. When I manually create it, it creates it just fine, but for some reason, when I try to automate its creation, it doesn't include both values in the Datalabels, just the Y value (the value in the second column of data). here...