C# Programming
07-02-2009, 09:30 PM
Hello,
I am trying to create a RangeColumn chart in Visual Studio 2008 with C#. All of my data is being brought in through a DB and is fairly simple.
I have two columns, a category and a value.
I want the first category to be displayed normally with y= 0 and then go to y= 200. Then I want the second category to start at y=200 then go to y=300, so basically it would not be starting at zero anymore. Ive heard this referred to as a waterfall chart, but not entirely sure.
I do not how to do this with just two columns of data. Do I need to create a query that does all of the math or is there a way do to this through the properties in MSChart?
Data
Category Total
DEVICES 38111
PLANT 6063
IMPROVEMENTS 2266
NETWORK 12507
OTHER 2734
SERVER 1092
STORAGE 318
ex
DEVICES: x=0, y1= 0, y2= 38111
PLANT: x=1, y1= 38111, y2 = 44174
IMPROVEMENTS: x=2, y1= 44174, y2 = 46440
I have been making all of the charts entirely through the design mode of Visual Studio 2008, and have not played with the code at all.
I would be forever indebt to you if you could help out. Thanks!
JM
I am trying to create a RangeColumn chart in Visual Studio 2008 with C#. All of my data is being brought in through a DB and is fairly simple.
I have two columns, a category and a value.
I want the first category to be displayed normally with y= 0 and then go to y= 200. Then I want the second category to start at y=200 then go to y=300, so basically it would not be starting at zero anymore. Ive heard this referred to as a waterfall chart, but not entirely sure.
I do not how to do this with just two columns of data. Do I need to create a query that does all of the math or is there a way do to this through the properties in MSChart?
Data
Category Total
DEVICES 38111
PLANT 6063
IMPROVEMENTS 2266
NETWORK 12507
OTHER 2734
SERVER 1092
STORAGE 318
ex
DEVICES: x=0, y1= 0, y2= 38111
PLANT: x=1, y1= 38111, y2 = 44174
IMPROVEMENTS: x=2, y1= 44174, y2 = 46440
I have been making all of the charts entirely through the design mode of Visual Studio 2008, and have not played with the code at all.
I would be forever indebt to you if you could help out. Thanks!
JM