User (Legacy) Posted July 18, 2004 Report Share Posted July 18, 2004 I am generating a 2d bar chart on the fly and it is stacking by default... ie. I am giving it a 5-column dataset. It is getting translated as 1-title column and 4 series which is all good. eg. periodname revenue cos a'cs rec debt tax 2001 300 30 50 40 45 2002 300 30 50 40 45 2003 300 30 50 40 45 I set the chart gallery to BAR - but for som reason it is displaying this as a stacked bar chart. I've even tried explicitly turning off stacking - but it seems to have no effect (Chart1.Stacked = Stacked.No). Any ideas? Thanks, Dan. Link to comment Share on other sites More sharing options...
User (Legacy) Posted July 18, 2004 Author Report Share Posted July 18, 2004 Actually - I'm slightly confused. It's not displaying as "stacked". Whats actually happening is that for each period - the bars are all in front or behind each other - not side by side - (I can see this using the transparent property). So for example - the table below should have periods along the x-axis (its doing this OK) and then 5 bars (side-by-side) above each period. Why is it putting the bars all in front/behind one another? "Dan Walls" <wallsy@hotmail.com> wrote in message news:Aoah4uMbEHA.3080@webserver3.softwarefx.com... > I am generating a 2d bar chart on the fly and it is stacking by default... > ie. I am giving it a 5-column dataset. It is getting translated as 1-title > column and 4 series which is all good. > eg. > > periodname revenue cos a'cs rec debt tax > 2001 300 30 50 40 45 > 2002 300 30 50 40 45 > 2003 300 30 50 40 45 > > I set the chart gallery to BAR - but for som reason it is displaying this as > a stacked bar chart. I've even tried explicitly turning off stacking - but > it seems to have no effect (Chart1.Stacked = Stacked.No). > > Any ideas? > > Thanks, > Dan. > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted July 18, 2004 Author Report Share Posted July 18, 2004 Don't worry - I've found the cluster property. dan "Dan Walls" <wallsy@hotmail.com> wrote in message news:Aoah4uMbEHA.3080@webserver3.softwarefx.com... > I am generating a 2d bar chart on the fly and it is stacking by default... > ie. I am giving it a 5-column dataset. It is getting translated as 1-title > column and 4 series which is all good. > eg. > > periodname revenue cos a'cs rec debt tax > 2001 300 30 50 40 45 > 2002 300 30 50 40 45 > 2003 300 30 50 40 45 > > I set the chart gallery to BAR - but for som reason it is displaying this as > a stacked bar chart. I've even tried explicitly turning off stacking - but > it seems to have no effect (Chart1.Stacked = Stacked.No). > > Any ideas? > > Thanks, > Dan. > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.