Customize a Chart in excel via VBA

Question

0.00/5 (No votes)

See more:

Hello Everybody !!.

I´m working in a project with VBA and I´d really appreciate if somebody could show me how to customize a chart (manipulate individually each element, or column of the seriescollection, give them a different color, height, width, etc ....), or give me a tip about where to find detailed information about it.

Of course I´d been looking for it, but I really need to save time.

Greatings from México City !!!!

Posted 23-Apr-15 6:21am

Miguel Altamirano Morales

Add a Solution

2 solutions

Solution 2

where to find detailed information about it?

For example, here: Chart Object (Excel)[^]
See the samples here: Creating Charts in Excel 2003 Using Visual Basic for Applications Code[^]

Posted 23-Apr-15 9:35am

Maciej Los

Comments

Miguel Altamirano Morales 23-Apr-15 16:09pm

Thanks a lot, Maciej

Maciej Los 24-Apr-15 1:53am

You're very welcome, Miguel ;)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2015-04-23T06:52:00

Solution 1

Actually, all you need to do is record a macro doing all the various things to a chart that you want to. Then you can see the code necessary to do what you want.

Posted 23-Apr-15 6:52am

ZurdoDev

Comments

Miguel Altamirano Morales 23-Apr-15 13:24pm

Thanks a lot RyanDev. I already have done and know about this, I just don´t have much experience with excel and I haven´t been able to find how to do the things I want to do, even manually.

But I´m going to keep searching the way you suggested me. I know it`s just a matter of a little bit of time more.

Thanks for your advice. It`s a good one and I marked it as "accepted". I hope I did it well.

ZurdoDev 23-Apr-15 13:34pm

What specific issues are you unaware of how to do?

Miguel Altamirano Morales 23-Apr-15 14:28pm

I want to manipulate separately each one of the columns or rectangles of the seriescollection of a chart.

I mean give a color to the first three columns, another color to the next 3 columns, and so on.

If I could find the properties and methods of the seriescollections objet then I would not have to deal with excel, just Visual Basic, witch i know better.

(Forgive my english, I`m a mexican citizen, where even the president doesn´t speak english well).

Miguel Altamirano Morales 23-Apr-15 14:31pm

I just can´t find via excel the type of chart the client wants. Maybe because I have office 2013 and the example they gave me it´s in office 2010.