Re: Creating Bar Graphs

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Robert,

The bars are showing a blank image if the
value is the same as the maxvalue which makes since since 60/60 = 0

I would hope 60\60 == 1 :-)

I am no web expert but I would think you want to align your images to the
bottom of the cell, you have:

tc.VerticalAlign = VerticalAlign.Top;

which would align the images to the top of the cell which is okay if you
want an inverted graph, but you probably want to align them to the bottom?
--
http://www.markdawson.org


"robert.q.johnson@xxxxxxxxxxxxxxxxxx" wrote:

Here is my current code. The bars are showing a blank image if the
value is the same as the maxvalue which makes since since 60/60 = 0.
The maxHieght is a constant of 120. The other graphs don't size
correctly to the data value 4 value / 60 maxValue * 120 = 8 but the
image is close to the top of the cell. Image width is a constant of
30.

private void PaintPlacements(DataTable dtPlacements)
{
DataRow[] rows = dtPlacements.Select();

double maxPlacements = Double.Parse(dtPlacements.Compute

("Max(PLACEMENTS_NBR)", "").ToString());
double maxPerformer = Double.Parse(dtPlacements.Compute

("Max(BEST_PERFORMER_NBR)", "").ToString());
double[] maxValue = {maxPlacements, maxPerformer};
tblPlacements.Rows.Add(AddPlacementGraphs(rows, maxValue,
ScorecardData.ImageWidth));
}

private TableRow AddPlacementGraphs(DataRow[] rows, double[] maxValue,
int barWidth)
{
double graphData;
double graphHeight;
TableRow tr = new TableRow();

foreach(DataRow row in rows)
{
TableCell tc = new TableCell();
graphData = Double.Parse(row["PLACEMENTS_NBR"].ToString());
graphHeight = (graphData / maxValue[0] *
ScorecardData.MaximumHeight);
tc.Text = "<img border=0 src=../images/spacer1.gif" +
" height=" + Math.Round(graphHeight, 0) +
" width=" + barWidth + ">";
tc.BackColor = Color.FromName("Blue");
tc.VerticalAlign = VerticalAlign.Top;
tr.Cells.Add(tc);
tc = null;

tc = new TableCell();
graphData = Double.Parse(row["BEST_PERFORMER_NBR"].ToString());
graphHeight = (graphData / maxValue[1] *
ScorecardData.MaximumHeight);
tc.Text = "<img border=0 src=../images/spacer1.gif" +
" height=" + Math.Round(graphHeight, 0) +
" width=" + barWidth + ">";
tc.BackColor = Color.FromName("CornflowerBlue");
tc.VerticalAlign = VerticalAlign.Top;
tr.Cells.Add(tc);
tc = null;
}
return tr;
}




Mark R. Dawson wrote:
Are rowValue and maxRowValue both integer values? You need to make sure at
least on of those values is a floating point number otherwise you are just
going to end up with 0's.

When you say not being sized correctly, what exactly do you mean?

Mark.
--
http://www.markdawson.org


.

Relevant Pages

  • Re: 2D Dynamic Time Warping Algorithm
    ... I need a fast and good 2D Dynamic Time Warping Algorithm. ... Total Computational Complexity is O. ... I suspect that I can't align that author's images, ...
    (sci.image.processing)
  • Re: Aligning Pictures
    ... is there a way to easily centre images in PowerPoint - i.e. at ... The align tool on the drawing toolbar lets you choose Align To Slide then ... The free PPTools StarterSet add-in lets you do this all (and size the ... Oh, and one other thing, is there any way to set the 'Insert picture from ...
    (microsoft.public.powerpoint)
  • Re: Alignment of cross marks between two images
    ... The images contain rectangular features and I want to align them. ... there are just planar rotation (1 DOF) and translation maybe ...
    (sci.image.processing)
  • Re: Images in tables ie7 problem
    ... I have a small problem with ie7 displaying a table. ... align the images in it properly. ... Find the file online here: ...
    (comp.infosystems.www.authoring.html)