Jump to content
Software FX Community
cka

How to create a combination chart

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...