Jump to content
Software FX Community

Building Chart through code


User (Legacy)

Recommended Posts

I am having problems constructing my chart. I bind a dataset and use

DataTypes, but it doesn't look right. I guess because it is a crosstab?

Anyway, how do I add series, labels, and a legend manually?

I am working from a table that is already pivoted and looks like this:

Company_Name

Date1

Date2

Date3

etc....

the first column is a row header (Legend Item), and the rest contain values.

The column names will become the X-Axis labels, and the rows will be

individual series. I can't find any code examples. Can someone post

something?

Thanks

Mike

Link to comment
Share on other sites

I am having problems constructing my chart. I bind a dataset and use

DataTypes, but it doesn't look right. I guess because it is a crosstab?

Anyway, how do I add series, labels, and a legend manually?

I am working from a table that is already pivoted and looks like this:

Company_Name

Date1

Date2

Date3

etc....

the first column is a row header (Legend Item), and the rest contain values.

The column names will become the X-Axis labels, and the rows will be

individual series. I can't find any code examples. Can someone post

something?

Thanks

Mike

Link to comment
Share on other sites

Also, I need to read data from ROWS, not columns.

Thanks!

"Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> I am having problems constructing my chart. I bind a dataset and use

> DataTypes, but it doesn't look right. I guess because it is a crosstab?

>

> Anyway, how do I add series, labels, and a legend manually?

>

> I am working from a table that is already pivoted and looks like this:

>

> Company_Name

> Date1

> Date2

> Date3

> etc....

>

> the first column is a row header (Legend Item), and the rest contain

values.

> The column names will become the X-Axis labels, and the rows will be

> individual series. I can't find any code examples. Can someone post

> something?

>

> Thanks

>

> Mike

>

>

Link to comment
Share on other sites

Also, I need to read data from ROWS, not columns.

Thanks!

"Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> I am having problems constructing my chart. I bind a dataset and use

> DataTypes, but it doesn't look right. I guess because it is a crosstab?

>

> Anyway, how do I add series, labels, and a legend manually?

>

> I am working from a table that is already pivoted and looks like this:

>

> Company_Name

> Date1

> Date2

> Date3

> etc....

>

> the first column is a row header (Legend Item), and the rest contain

values.

> The column names will become the X-Axis labels, and the rows will be

> individual series. I can't find any code examples. Can someone post

> something?

>

> Thanks

>

> Mike

>

>

Link to comment
Share on other sites

I answered my own questions... it was pretty easy.

One problem:

I can't get the y axis min to adjust to something meaningful. I have large

scale numbers being passed in manually. (15 to 40 + thousand) the min is

always 0, which skews the chart. Any suggestions?

"Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> I am having problems constructing my chart. I bind a dataset and use

> DataTypes, but it doesn't look right. I guess because it is a crosstab?

>

> Anyway, how do I add series, labels, and a legend manually?

>

> I am working from a table that is already pivoted and looks like this:

>

> Company_Name

> Date1

> Date2

> Date3

> etc....

>

> the first column is a row header (Legend Item), and the rest contain

values.

> The column names will become the X-Axis labels, and the rows will be

> individual series. I can't find any code examples. Can someone post

> something?

>

> Thanks

>

> Mike

>

>

Link to comment
Share on other sites

I answered my own questions... it was pretty easy.

One problem:

I can't get the y axis min to adjust to something meaningful. I have large

scale numbers being passed in manually. (15 to 40 + thousand) the min is

always 0, which skews the chart. Any suggestions?

"Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> I am having problems constructing my chart. I bind a dataset and use

> DataTypes, but it doesn't look right. I guess because it is a crosstab?

>

> Anyway, how do I add series, labels, and a legend manually?

>

> I am working from a table that is already pivoted and looks like this:

>

> Company_Name

> Date1

> Date2

> Date3

> etc....

>

> the first column is a row header (Legend Item), and the rest contain

values.

> The column names will become the X-Axis labels, and the rows will be

> individual series. I can't find any code examples. Can someone post

> something?

>

> Thanks

>

> Mike

>

>

Link to comment
Share on other sites

There should have been a bool property called ForceZero (it currently

defaults to true) but it is not exposed in the lite version, we will correct

this issue in our next build.

--

Regards,

JC

Software FX Support

"Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

news:3x579$5eCHA.2308@webserver1.softwarefx.com...

> I answered my own questions... it was pretty easy.

>

> One problem:

>

> I can't get the y axis min to adjust to something meaningful. I have large

> scale numbers being passed in manually. (15 to 40 + thousand) the min is

> always 0, which skews the chart. Any suggestions?

>

>

>

> "Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

> news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> > I am having problems constructing my chart. I bind a dataset and use

> > DataTypes, but it doesn't look right. I guess because it is a crosstab?

> >

> > Anyway, how do I add series, labels, and a legend manually?

> >

> > I am working from a table that is already pivoted and looks like this:

> >

> > Company_Name

> > Date1

> > Date2

> > Date3

> > etc....

> >

> > the first column is a row header (Legend Item), and the rest contain

> values.

> > The column names will become the X-Axis labels, and the rows will be

> > individual series. I can't find any code examples. Can someone post

> > something?

> >

> > Thanks

> >

> > Mike

> >

> >

>

>

Link to comment
Share on other sites

There should have been a bool property called ForceZero (it currently

defaults to true) but it is not exposed in the lite version, we will correct

this issue in our next build.

--

Regards,

JC

Software FX Support

"Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

news:3x579$5eCHA.2308@webserver1.softwarefx.com...

> I answered my own questions... it was pretty easy.

>

> One problem:

>

> I can't get the y axis min to adjust to something meaningful. I have large

> scale numbers being passed in manually. (15 to 40 + thousand) the min is

> always 0, which skews the chart. Any suggestions?

>

>

>

> "Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

> news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> > I am having problems constructing my chart. I bind a dataset and use

> > DataTypes, but it doesn't look right. I guess because it is a crosstab?

> >

> > Anyway, how do I add series, labels, and a legend manually?

> >

> > I am working from a table that is already pivoted and looks like this:

> >

> > Company_Name

> > Date1

> > Date2

> > Date3

> > etc....

> >

> > the first column is a row header (Legend Item), and the rest contain

> values.

> > The column names will become the X-Axis labels, and the rows will be

> > individual series. I can't find any code examples. Can someone post

> > something?

> >

> > Thanks

> >

> > Mike

> >

> >

>

>

Link to comment
Share on other sites

Thank you! That would be a huge help.

Right now I am scanning the dataset for max and min values, then applying

them with a little buffer.

Mike

"Software FX Support" <support@softwarefx.com> wrote in message

news:It6TDpCfCHA.2784@webserver1.softwarefx.com...

> There should have been a bool property called ForceZero (it currently

> defaults to true) but it is not exposed in the lite version, we will

correct

> this issue in our next build.

>

> --

> Regards,

>

> JC

> Software FX Support

> "Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

> news:3x579$5eCHA.2308@webserver1.softwarefx.com...

> > I answered my own questions... it was pretty easy.

> >

> > One problem:

> >

> > I can't get the y axis min to adjust to something meaningful. I have

large

> > scale numbers being passed in manually. (15 to 40 + thousand) the min is

> > always 0, which skews the chart. Any suggestions?

> >

> >

> >

> > "Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

> > news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> > > I am having problems constructing my chart. I bind a dataset and use

> > > DataTypes, but it doesn't look right. I guess because it is a

crosstab?

> > >

> > > Anyway, how do I add series, labels, and a legend manually?

> > >

> > > I am working from a table that is already pivoted and looks like this:

> > >

> > > Company_Name

> > > Date1

> > > Date2

> > > Date3

> > > etc....

> > >

> > > the first column is a row header (Legend Item), and the rest contain

> > values.

> > > The column names will become the X-Axis labels, and the rows will be

> > > individual series. I can't find any code examples. Can someone post

> > > something?

> > >

> > > Thanks

> > >

> > > Mike

> > >

> > >

> >

> >

>

>

Link to comment
Share on other sites

Thank you! That would be a huge help.

Right now I am scanning the dataset for max and min values, then applying

them with a little buffer.

Mike

"Software FX Support" <support@softwarefx.com> wrote in message

news:It6TDpCfCHA.2784@webserver1.softwarefx.com...

> There should have been a bool property called ForceZero (it currently

> defaults to true) but it is not exposed in the lite version, we will

correct

> this issue in our next build.

>

> --

> Regards,

>

> JC

> Software FX Support

> "Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

> news:3x579$5eCHA.2308@webserver1.softwarefx.com...

> > I answered my own questions... it was pretty easy.

> >

> > One problem:

> >

> > I can't get the y axis min to adjust to something meaningful. I have

large

> > scale numbers being passed in manually. (15 to 40 + thousand) the min is

> > always 0, which skews the chart. Any suggestions?

> >

> >

> >

> > "Mike Barrett" <mbarrett_nospam@impactrx.com> wrote in message

> > news:11mpq$4eCHA.2308@webserver1.softwarefx.com...

> > > I am having problems constructing my chart. I bind a dataset and use

> > > DataTypes, but it doesn't look right. I guess because it is a

crosstab?

> > >

> > > Anyway, how do I add series, labels, and a legend manually?

> > >

> > > I am working from a table that is already pivoted and looks like this:

> > >

> > > Company_Name

> > > Date1

> > > Date2

> > > Date3

> > > etc....

> > >

> > > the first column is a row header (Legend Item), and the rest contain

> > values.

> > > The column names will become the X-Axis labels, and the rows will be

> > > individual series. I can't find any code examples. Can someone post

> > > something?

> > >

> > > Thanks

> > >

> > > Mike

> > >

> > >

> >

> >

>

>

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...