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, 2022 in Others by Kithuzzz
• 38,010 points
301 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, 2022 by narikkadan
• 63,700 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, 2022 in Others by Kithuzzz
• 38,010 points
212 views
0 votes
1 answer

VBA Export as PDF and Save to Location with name as per a Cell in the worksheet

Following is the code that gets generated ...READ MORE

answered Jan 20, 2023 in Others by narikkadan
• 63,700 points
1,595 views
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

Try this: Sub FillDates() Dim ...READ MORE

answered Jan 24, 2023 in Others by narikkadan
• 63,700 points
757 views
0 votes
1 answer

Getting data out of a cell with a #NAME? error in Excel VBA

If you need VBA, use .Formula: Dim f As ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,700 points
468 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,740 points
980 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
3,331 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, 2022 in Others by gaurav
• 23,260 points
637 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, 2022 in Others by Edureka
• 13,670 points
854 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, 2022 in Others by narikkadan
• 63,700 points
786 views
0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,700 points
964 views
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