Jump to content
Software FX Community

Duplicate Excel chart in ChartFX


User (Legacy)

Recommended Posts

Hello.

I'm trying to duplicate the attached chart from Excel in ChartFX. I've been

able to produce something like this:

but have not been able to group the years together and keep the colors in

the 2 groups the same. Essentially I want to show the Individual OOP,

Individual Premium Contribution, and Plan Sponsor Contribution as 3 colors

and then have 2 "lines" (for lack of a better word) above each year -- one

representing large employers and one representing small employers. This

seems like it would be very easy, but I'm clearly missing something.

Can someone perhaps point out the obvious?

Thanks.

Link to comment
Share on other sites

I figured out how to do this. But now I can only seem to get the chart to

show me the value of the "top" piece of the stack. How do I get all 3 values

to display? I've set PointLabels = true but that seems to have no effect.

Perhaps the labels are there, but they're just being "covered" by the

"layers" in the chart? If so, how do I bring them to the front? And, while

I'm on it, how do I display a total at the top of each bar?

Thanks for any insight.

Brian

"Brian Elcock" <brian.elcock@mercer.com> wrote in message

news:gnbo26e%23FHA.3220@webserver3.softwarefx.com...

> Hello.

>

> I'm trying to duplicate the attached chart from Excel in ChartFX. I've

been

> able to produce something like this:

>

>

>

>

>

> but have not been able to group the years together and keep the colors in

> the 2 groups the same. Essentially I want to show the Individual OOP,

> Individual Premium Contribution, and Plan Sponsor Contribution as 3 colors

> and then have 2 "lines" (for lack of a better word) above each year -- one

> representing large employers and one representing small employers. This

> seems like it would be very easy, but I'm clearly missing something.

>

> Can someone perhaps point out the obvious?

>

> Thanks.

>

>

>

Attachments.zip

Link to comment
Share on other sites

>Perhaps the labels are there, but they're just being "covered" by the

>"layers" in the chart?

What version of ChartFX are you using ? If it is 6.2 or earlier this may be

the case, you will need to align the labels to the center (vertical) or to

the top so they are inside of the bar to which they belong.

--

Francisco Padron

www.chartfx.com

post-2107-13922378220258_thumb.gif

Link to comment
Share on other sites

ChartFX for .NET 6.2. Is there a newer version?

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:Eqpmi23%23FHA.3496@webserver3.softwarefx.com...

> >Perhaps the labels are there, but they're just being "covered" by the

> >"layers" in the chart?

>

> What version of ChartFX are you using ? If it is 6.2 or earlier this may

be

> the case, you will need to align the labels to the center (vertical) or to

> the top so they are inside of the bar to which they belong.

>

> --

> Francisco Padron

> www.chartfx.com

>

>

Link to comment
Share on other sites

That worked, thanks:

Chart18.PointLabelAlign = SoftwareFX.ChartFX.LabelAlign.Center |

SoftwareFX.ChartFX.LabelAlign.VCenter;

Is there a way to get the totals to display at the top of the bars? And, in

my case, I'm really comparing the same thing across large and small

employers. So, ideally, the Plan Sponsor Contribution would be the same

color for both large and small employers and I would have a label on the X

Axis below the year that labeled the left bar as large and the right bar as

small for each group. Is that possible?

"Brian Elcock" <brian.elcock@mercer.com> wrote in message

news:H3G6z0A$FHA.3220@webserver3.softwarefx.com...

> ChartFX for .NET 6.2. Is there a newer version?

>

> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

> news:Eqpmi23%23FHA.3496@webserver3.softwarefx.com...

> > >Perhaps the labels are there, but they're just being "covered" by the

> > >"layers" in the chart?

> >

> > What version of ChartFX are you using ? If it is 6.2 or earlier this may

> be

> > the case, you will need to align the labels to the center (vertical) or

to

> > the top so they are inside of the bar to which they belong.

> >

> > --

> > Francisco Padron

> > www.chartfx.com

> >

> >

>

>

Link to comment
Share on other sites

Thanks. Figured that part out as well. What about the totals at the top of

the bar? Is that possible?

"SoftwareFX Support" <noreply@softwarefx.com> wrote in message

news:7l70%23pN$FHA.3496@webserver3.softwarefx.com...

> You can customize the series colors by doing:

>

> chart.Series[i].Color = <your color>;

>

> You can create a UserLegendBox to display these three colors.

>

> Check the docs on User Legend Box for details.

>

> --

> Francisco Padron

> www.chartfx.com

>

>

Link to comment
Share on other sites

No. That one is not possible in Chart FX 6 because, as you discovered, the 

next bar segment will override the label of the previous one.

We added a new feature in Chart FX 7 (for VS 2005) that allows you to delay

the point label drawing to the end so that labels are drawn in a second

pass, after all points are drawn, this allows you to achieve what you are

looking for.

--

Francisco Padron

www.chartfx.com

"Brian Elcock" <brian.elcock@mercer.com> wrote in message

news:d6Mk3CU$FHA.3220@webserver3.softwarefx.com...

> Thanks. Figured that part out as well. What about the totals at the top of

> the bar? Is that possible?

>

> "SoftwareFX Support" <noreply@softwarefx.com> wrote in message

> news:7l70%23pN$FHA.3496@webserver3.softwarefx.com...

>> You can customize the series colors by doing:

>>

>> chart.Series[i].Color = <your color>;

>>

>> You can create a UserLegendBox to display these three colors.

>>

>> Check the docs on User Legend Box for details.

>>

>> --

>> Francisco Padron

>> www.chartfx.com

>>

>>

>

>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...