Horizontal Bar Chart With MSChart

[Roebuck]

Please could somebody tell me if (and how) it is possible to produce a horizontal bar chart using VB6 - I have tried the MSChart control but can only get a vertical bar chart.

My aim is to show the groups on the y axis (e.g. months) and the values extending horizontally on the x axis (e.g. number of sales)

Thanks in advance

 

[SkipVought]

Hi,

It's the ChartType property of the Chart OBject

Here's a list of type values
[tt]
Bar Clustered Bar xlBarClustered
3D Clustered Bar xl3DBarClustered
Stacked Bar xlBarStacked
3D Stacked Bar xl3DBarStacked
100% Stacked Bar xlBarStacked100
3D 100% Stacked Bar xl3DBarStacked100
[/tt]


Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Roebuck]

The closest option available under the MSChart control seems to be VtChChartType2dBar.

Either can this be made to display horizontally or how would I access the stacked bar options you mention above?

Thanks

 

[SkipVought]

OOPS

I just realized I gave you Excel Chart Options -- Sorry!

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JoanneA]

Did you manage to get a stacked bar chart?

 

[SkipVought]

JoanneA,

If you have a specific question, it might be better to start a new thread.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]