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

Watch MrExcel Video

This Week's Hot Topics

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
Top