activechart

I want to create a pie chart and set the source data. I've spent a long time searching, with this being the most helpful. I keep getting this error, "run time error 2147221080 (800401a8): automation error" for the following code. Sub createchart() Charts.Add With ActiveChart...

Hi Guys, I am having difficulty running a small report via Task Scheduler. It works fine updating form the database but this last code gives me a headache. The error says: "Run-time error '91': Object cariable or With block varible not set I know its the highligthed with red color, but just...

Hello Im trying to resize the chart area width and height using vba,but keep getting “shape is locked and cannot be resized” error. I am using basic commands such as: With ActiveChart .ChartArea.Height = 200 .ChartArea.Width= 50 End With Any way to work around this lock error? Thank you

Hi, I'm bored so I felt like making a pie chart of my cell phone data usage. I made a spreadsheet (table below) that has a column that labels each application and the corresponding data that it used. My macro then creates a second table of only the applications that used 2% or more of the total...

Hi all I've been scratching my head over this problem, it seems a little odd. I have a macro that creates and automatically populates an xy chart. On startup it works, but a few minutes in to using the spreadsheet it suddenly stops working and kicks out a 91 error. sometimes it will all of a...

Hi Goal: Format charts differently depending on type My code: If ActiveChart.ChartType = xlColumnClustered Then Call Ejmellem Problem: Somehow vba can't read which type the active chart is when running the code and therefore the Ejmellem isn't called. Half solution: For example if I define...