Jump to content
Software FX Community

Floating Bars


User (Legacy)
 Share

Recommended Posts

Bruce, 

One of the "tricks" I learned from Francisco was to turn on the DataEditor.

This will allow you to see the actual values of the series.

Your code creates values of -10, 0 ,10, 20.

20 ON 10 IS 30, hence your top value of 30 in the chart.

I think the problem in this code is in your last series:

"ChartFX.ValueEx(3, 0) = 20"

The sample is to create a floating bar chart starting with -20 and stack

values of 10 on top.

Your 4th series is valued at 20, not 10. I can read the code and understand

what you mean but poor computer...

I recently had some questions regarding the YFrom settings and had to write

some special code to check my data series. I couldn't count on positive or

negative numbers for a floating bar chart and had to check each series

begining and ending point to see how to insert the values into the arrays.

Steve

Just for fun, using the code you provided, converted to VBA (Access 2000)

the code looks like:

***************************

Dim ChartFX As Object

Set ChartFX = Me.Chart1

ChartFX.OpenDataEx COD_VALUES, 4, 1

ChartFX.OpenDataEx COD_INIVALUES, 4, 1

ChartFX.ValueEx(0, 0) = -10

ChartFX.IniValueEx(0, 0) = -20

ChartFX.ValueEx(1, 0) = 0

ChartFX.IniValueEx(1, 0) = -10

ChartFX.ValueEx(2, 0) = 10

ChartFX.IniValueEx(2, 0) = 0

ChartFX.ValueEx(3, 0) = 10 'corrected from 20

ChartFX.IniValueEx(3, 0) = 10

ChartFX.CloseData (COD_INIVALUES)

ChartFX.CloseData COD_VALUES

ChartFX.Stacked = CHART_STACKED

ChartFX.Axis.Item(AXIS_Y).Max = 60

ChartFX.Axis.Item(AXIS_Y).Min = -60

ChartFX.Axis.Item(AXIS_Y).Grid = True

ChartFX.DataEditor = True

Set ChartFX = Nothing

***************************

-----Original Message-----

From: Bruce Rhoades [ mailto:BruceR@mobiusg.com]

Sent: Thursday, December 30, 1999 7:40 AM

To: 'Steve Titus'

Subject: RE: Removing Zero Line Programmatically

Thanks, Steve. Using the AS_FORCEZERO removes those zero lines like I want

them to.

I have been having another problem that I was wondering if you could help me

with. I have emailed Francisco with this problem, as well as sent one to

general support and have not gotten a response.

I am trying to implement a floating, stacked bar chart using the code below:

m_pChartFX->Stacked = CHART_STACKED;

m_pChartFX->OpenDataEx(COD_VALUES, 4, 1);

m_pChartFX->OpenDataEx(COD_INIVALUES, 4, 1);

m_pChartFX->IniValueEx[0][0] = -20;

m_pChartFX->ValueEx[0][0] = -10;

m_pChartFX->IniValueEx[1][0] = -10;

m_pChartFX->ValueEx[1][0] = 10;

m_pChartFX->IniValueEx[2][0] = 0;

m_pChartFX->ValueEx[2][0] = 10;

m_pChartFX->IniValueEx[3][0] = 10;

m_pChartFX->ValueEx[3][0] = 10;

m_pChartFX->CloseData(COD_VALUES);

m_pChartFX->CloseData(COD_INIVALUES);

m_pChartFX->Axis->Item[AXIS_Y]->Min = -60;

Basically, there is just one stacked-bar in the chart, with 4 series. I want

it to start at -20 and extend to 20, with each series being of size 10. Now,

using the above code, all series EXCEPT for the 4th (topmost) series is of

size 10. Now, as you can see in the attached chart, the topmost series

extends from 10 to 30, even though I specify it having size 10:

m_pChartFX->ValueEx[3][0] = 10;

Now, one important thing to note is that I only have this problem when I use

negative values for the ValueEx and the IniValueEx. If the values are ALL

positive, the above code works just fine. As soon as they go negative,

however, I have problems like the one presented here.

What is going on here? Am I doing something wrong?

Thanks in advance

Bruce Rhoades

-----Original Message-----

From: Steve Titus [ mailto:stephent@hevanet.com]

Sent: Wednesday, December 29, 1999 9:13 PM

To: brhoades@mobiusg.com

Subject: Re: Removing Zero Line Programmatically

Bruce,

In the UI reference if you click the Axes tab then details it takes you to:

ChartName.Axis(AxisName).Style property

seems this is toggled with:

ChartName.Axis(AxisName).Style = AS_BREAKZERO

and

ChartName.Axis(AxisName).Style = AS_FORCEZERO

Is this your question?

Steve

Bruce Rhoades <brhoades@mobiusg.com> wrote in message

news:DE0379D14694D211B4CE00609770710D045786@sftfx-221.wamnet.net...

> I seem to be unable to find a property with the axis object to remove the

> zero lines from my chart. I can do it with the property dialog by going to

> the Axes tab, then clicking on Details and then clicking off the zero

line.

>

> Anyone out there know of a way to do this programmatically? I am using

VC++,

> but sample code of any sort would be appreciated.

>

> Thanks

>

> Bruce Rhoades

>

Link to comment
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.

 Share

×
×
  • Create New...