cka Posted December 5, 2007 Report Share Posted December 5, 2007 Hi, I'm evaluating your product and I'm trying to figure out how configure a combination chart displaying all series as bars except for the last one that should be a line. Dataset example: Product , Hour , Qty Product A, 01:00, 27 Product B, 01:00, 39 Target, 01:00, 50 Product A, 02:00, 32 Product B, 02:00, 34 Target, 02:00, 60 Is that possible? If so, how do I configure the chart? /Cka Quote Link to comment Share on other sites More sharing options...
Frank Posted December 5, 2007 Report Share Posted December 5, 2007 Yes. No problem. First you need to create a crosstab to pass the data to this chart so that a series is created for each distinct value in the Product Column (Column Header). Check the programmer's guide on the Cross Tab provider for more details. You can also do this using the Chart FX Wizard. After the data is setup, all you need to do is set the gallry for each series. You can do this in code or using the property grid at desing-time. In code it's something like: chart.AllSeries.Gallery = Gallery.Bar; chart.Series[2].Gallery = Gallery.Lines; // Third series is the LIne Quote Link to comment Share on other sites More sharing options...
cka Posted December 10, 2007 Author Report Share Posted December 10, 2007 The number of series can and will vary, is it possible to use a variable for the last index, like chart.Series[chart.Series.Length-1].Gallery = Gallery.Lines? regards, Christer Quote Link to comment Share on other sites More sharing options...
Frank Posted December 10, 2007 Report Share Posted December 10, 2007 Yes. Of course. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.