Combine Two charts in excel through vb.net

Question

0.00/5 (No votes)

See more:

Hi frnds..

can anyone advice me how to combine bar and line chart in excel through vb.net..

Successfully i created line chart through vb.net and its perfectly working.. i have to combine bar chart in the same line chart..

Thanks

Posted 26-Jun-12 22:17pm

nithibs

Add a Solution

1 solution

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 · 2012-06-27T02:23:00

Solution 1

You simply add another series to the same chart and then set

C#

ChartObject.Series[seriesName].ChartType = SeriesChartType.Line;

or whatever type you want.

Posted 27-Jun-12 2:23am

ZurdoDev

Comments

nithibs 29-Jun-12 5:00am

I tried your above solution and doesn't work what i need is on the left side line chart for some values and right side bar chart for some other values in a single chart.

ZurdoDev 29-Jun-12 7:48am

I doubt that is possible. What you are describing is 2 charts, like you said. The x axis wouldn't work if you do it the way you are asking. Can you explain why? Maybe there is a different approach. But it sounds like you'll have to stick to 2 charts.