Creating a chart in VBA with 2 different Types

0 votes
In VBA, I'm attempting to programmatically build a chart. Three series must be present in the chart, two of which must be xlColumnStacked and one of which must be xlColumnClustered. One series will be of the xlColumnClustered type, while the other two will be stacked, according to the plan. The two columns will then be compared side by side as a result.

Can this be done?
Oct 10 in Others by Kithuzzz
• 20,660 points
50 views

1 answer to this question.

0 votes

Can you carry this out by hand using the UI? Is what you're doing in the UI and the code conceptually equivalent? You must choose the exact series whose type you want to alter using the UI. Instead of setting the type of the entire chart, are you doing this in code?

For anything to do with Excel charts, I would recommend John Peltier's site

answered Oct 11 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

Creating a chart in Excel that ignores #N/A or blank cells

A dynamic data series will be used ...READ MORE

Nov 2 in Others by Kithuzzz
• 20,660 points
27 views
0 votes
1 answer
0 votes
1 answer

Create a User Account in Windows 10 with PowerShell.

Hi@akhtar, To create a new user account without ...READ MORE

answered Oct 7, 2020 in Others by MD
• 95,380 points
228 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
454 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,227 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
71 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
210 views
0 votes
1 answer

I have a problem with counta function in VBA

When the worksheet name has a space, ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
54 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP