charts vba formatting

Hello guys, im creating visual representation of my data, and i want to create charts. The code to create the chart is: Range("T1:T32,V1:V32,X1:X32").Select ActiveSheet.Shapes.AddChart2(201, xlColumnClustered).Select ActiveChart.SetSourceData Source:=Range( _...

Hi, I have a stacked bar chart which is in essence a Gantt chart. I want it to work on multiple projects however for this to happen I need the Minimum values dynamic. I got the below code from another forum yet it keeps producing the following error Run Time Error -2147467259 (80004005)'...

Hi, I have two list: M1_LIST = values (like 1, 5, 6 etc) Country_all_list = values names (Audi, BMW etc) Now I'm creating chart: Dim charts_1 As ChartObject Set charts_1 = sCountry.ChartObjects.Add(Left:=300, Top:=175, Width:=400, Height:=300) With charts_1 .Chart.ChartType =...

<tbody> A B C D E N O P 1 Month Jan'13 Feb'13 Mar'13 Jan'14 Feb'14 Mar'14 2 Assets 32 31 30 29 29 27 3 Equity 4.3 4.2 4.3 4.1 4.3 4.3 </tbody> I have a table as above and have created a bar chart that compares 3 months of 2013 with 3 months of 2014. The values of Apr'13 thru Dec'13 are...

I'm using John Peltier's Formatting of charts by Category label code from VBA Conditional Formatting of Charts by Category Label - Peltier Tech Blog to format the colour of Column and Pie charts in Excel 2010. With ch.Chart.SeriesCollection(1) vCategories = .XValues For...