Chart Y-axis Values Problem

I created a chart using some calculated fields, the calculations are working
correctly (I manually checked the math), but the Y axis values are way off.
The highest field value generated was 18,544 but the scale on the chart was
showing 500,000 with the bar reaching nearly to the top. I could understand
if the scale was just off and the bar stopped at the correct position, but
not only is the scale off, the bar doesn't correctly represent the value
either. Because this report will be used for several customers I can't
manually set a limit for the Y-axis. I turned off the labels for the Y-axis
so that I can use the chart, but I would prefer being able to see the labels.
I have installed SP1. Any help would be appreciated.
JoeHi, you can convert the scale of your chart in a expression in the RDL; try
it.
John Bocachica
Colombia
"JHoward" <JHoward@.discussions.microsoft.com> wrote in message
news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
>I created a chart using some calculated fields, the calculations are
>working
> correctly (I manually checked the math), but the Y axis values are way
> off.
> The highest field value generated was 18,544 but the scale on the chart
> was
> showing 500,000 with the bar reaching nearly to the top. I could
> understand
> if the scale was just off and the bar stopped at the correct position, but
> not only is the scale off, the bar doesn't correctly represent the value
> either. Because this report will be used for several customers I can't
> manually set a limit for the Y-axis. I turned off the labels for the
> Y-axis
> so that I can use the chart, but I would prefer being able to see the
> labels.
> I have installed SP1. Any help would be appreciated.
> Joe|||Note: expression-based min/max/intervals will only be available on RS2005.
Joe, can you post a simplified report which runs e.g. based on Northwind
data and reproduces the issue?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Bocachica (Colombia)" <jbocachica@.gmail.com> wrote in message
news:e%23FQGGl%23EHA.1084@.tk2msftngp13.phx.gbl...
> Hi, you can convert the scale of your chart in a expression in the RDL;
try
> it.
> John Bocachica
> Colombia
> "JHoward" <JHoward@.discussions.microsoft.com> wrote in message
> news:78D0BEDF-A212-4B07-9641-9A1615E6168F@.microsoft.com...
> >I created a chart using some calculated fields, the calculations are
> >working
> > correctly (I manually checked the math), but the Y axis values are way
> > off.
> > The highest field value generated was 18,544 but the scale on the chart
> > was
> > showing 500,000 with the bar reaching nearly to the top. I could
> > understand
> > if the scale was just off and the bar stopped at the correct position,
but
> > not only is the scale off, the bar doesn't correctly represent the value
> > either. Because this report will be used for several customers I can't
> > manually set a limit for the Y-axis. I turned off the labels for the
> > Y-axis
> > so that I can use the chart, but I would prefer being able to see the
> > labels.
> > I have installed SP1. Any help would be appreciated.
> >
> > Joe
>