vba chart problem

  1. M

    Chart based on table not updating as expected (VBA)

    Hi I've written a macro which updates a clustered column chart in Sheet 1 that's based on data in a table in Sheet 2. However, the chart is not fully updating. The ‘source data’ for the chart is =Table5[#All] (based on a table that currently exists in Sheet2). The table in Sheet 2 is...
  2. E

    VBA Chart Error: The object is no longer valid

    Hello, I have a Charting AddIn (created in 2004), which formats selected data into different charts. All of the charts work well, except: Pie, Pie of Pie, Bar of Pie and Doughnut. For those types of charts I get the following error: Error No: 2147483643 Description: This object is no longer...
  3. D

    VBA code error

    Need some help with this VBA code, I can't see why it doesn't work. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Select Case Target.Address Case "$E$2" ActiveSheet.ChartObjects("Chart 2").Chart.Axes(xlCategory) _ .MaximumScale =...
  4. D

    Customizing Charts in VBA

    I was wondering if there is away of creating a code using VBA that would exclude data when it has a value of 0 from the graph. This is because I have an ever changing set of data but values of 0 are not needed for the scatter graph.
  5. L

    vba chart problem.

    hi I have a vba question/problem regarding inputing the xvalues and yvalues for a data series into a chart using vba. I used the macro recorder and manually inputed into the 'Source Data' window/menu of the chart the x and y values for the data series, which generated the following...

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