vba chart problem

I use a vba macro to generate a chart that combines 2 lines with an area within the same axes. I use the area data series to emphasize that data rather than using other line characteristics such as bold, color or line width. The following vba commands are written after the data series and...

Hi I never used VBA for Excel before. Why this command give error, second one also, but If I uncomment "On Error..." second one fill chart as should be. Sorry for picture, not source. I used this at work, now I'm at home... Any advice? Many thanks, BaGRoS

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

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

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

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.

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