chartobjects

Hi Folks, I am trying to figure out the syntax to assign individual charts to individual variables in my macro rather than loop through each chart to send them to PowerPoint. Using the syntax below throws a run-time error 91, Object variable or With block variable not set even though I have...

Sub smarterway() Dim chartfirst As ChartObject Dim rngChart As Range Set rngChart = Range("D3:J20") Set chartfirst = ActiveSheet.ChartObjects.Add(Left:=rngChart.Left, Top:=rngChart.Top, Width:=rngChart.Width, Height:=rngChart.Height) [....] For this...

<tbody> I'm having trouble with ChartObjects: I'm potentially placing patches on patches while missing something fundamental. I'm using VBA in excel:mac 2011. I have 4 ChartObjects on a sheet, taking values from different data ranges and displaying them identically. They are simple...

I’ve created a stacked bar graph. Now using visual basic I'm trying to format the data series for each of the series, and fill it with a stacked and scaled image. The images are pictures of numbers from 0 – 9. Here’s a snippet of the code I’m struggling with:</SPAN> With...

I have a chat where I summarize the results from a series of files. The file names are dynamic, there is a need to constantly update the summary workbook. The idea was to use a code from peltiertiertech utility to do the job. when assigning values directly to the old and new strings I want to...