Normalizing an Area Chart

[rcoutts]

I'm a newbie that created an Area Chart using the Graph Wizard. It's
almost what I need, except the Y-axis shows an accumulated count of
the values. What I need is to normalized the values so that the
represent a percentage, rather than an accumulated value. E.g., that
the total across the X-Axis is always 100% and the area shows the
percentage contribution of each value being plotted.

I could create a query that generates normalized values and then graph
those, but I'm hoping there's a simple way to do this without the
intermediate query.

Thanks in advance,
Rich

 

[rcoutts]

I'm a newbie that created an Area Chart using the Graph Wizard. It's
almost what I need, except the Y-axis shows an accumulated count of
the values. What I need is to normalized the values so that the
represent a percentage, rather than an accumulated value. E.g., that
the total across the X-Axis is always 100% and the area shows the
percentage contribution of each value being plotted.

I could create a query that generates normalized values and then graph
those, but I'm hoping there's a simple way to do this without the
intermediate query.

Thanks in advance,
Rich

I should have listed the SQL generated by the Wizard:

TRANSFORM Count(*) AS [Count]
SELECT (Format([Date],"\'yy\.q")) AS Expr1
FROM qryDreamNeeds
GROUP BY (Year([Date])*4+DatePart("q",[Date])-1), (Format([Date],"\'yy
\.q"))
PIVOT qryDreamNeeds.Need1;

As I mentioned in my original post, I need to display the areas as a
percentage, rather than a count.

Rich

 

[Guest]

When you are going through the chart wizard, does it automatically change
your Y-axis to something like SumOfFieldName? If so, you can double click
it, and select None. I had a similar problem with a pie chart and it worked
for me.
--
Dennis

I'm a newbie that created an Area Chart using the Graph Wizard. It's
almost what I need, except the Y-axis shows an accumulated count of
the values. What I need is to normalized the values so that the
represent a percentage, rather than an accumulated value. E.g., that
the total across the X-Axis is always 100% and the area shows the
percentage contribution of each value being plotted.

I could create a query that generates normalized values and then graph
those, but I'm hoping there's a simple way to do this without the
intermediate query.

Thanks in advance,
Rich

I should have listed the SQL generated by the Wizard:

TRANSFORM Count(*) AS [Count]
SELECT (Format([Date],"\'yy\.q")) AS Expr1
FROM qryDreamNeeds
GROUP BY (Year([Date])*4+DatePart("q",[Date])-1), (Format([Date],"\'yy
\.q"))
PIVOT qryDreamNeeds.Need1;

As I mentioned in my original post, I need to display the areas as a
percentage, rather than a count.

Rich

 

[rcoutts]

When you are going through the chart wizard, does it automatically change
your Y-axis to something like SumOfFieldName? If so, you can double click
it, and select None. I had a similar problem with a pie chart and it worked
for me.

No, it's no doing anything like that. It's correctly counting the
number of occurrences of each value in the field, the way an Area
Chart is supposed to. I'm trying to force it to do something a little
out of the ordinary by making the counts always add up to 100 so that
I get a better sense of each values contribution in terms of a
percentage.

Rich

 

[Gigasoft]

Hi,

I don't believe any wizard or SQL is going to do this.

You will have to spoon feed the data. And if you're doing this, and
creating other complex charts, you may want to research Gigasoft
ProEssentials at www.gigasoft.com. A little more work, but your end users
will appreciate, and your product's competitiveness will be increased.
Especially when the chart is in the form and users can interact, and working
with lots of data, technical data, financial data, discontinuous data-time
data, multiple y axes, all types of annotations, and so much more.

best regards,

Robert Dede
Gigasoft, Inc.