datalabels

  1. F

    VBA Change Chart Title

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

    Chart data label position

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

    VBA to reposition data labels on a bubble chart so they do not overlap

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

    Problem with changing datalabels color after save the file and reopen

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

    Trendline DataLabels evaluating as Blank in VBA but still displayed correctly on Charts

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

    VBA Excel Chart: Copy Series Datalabel formats

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

    I need both Datalabels to be visible...on this VBA created chart...

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

Some videos you may like

This Week's Hot Topics

Top