How do chart axes set their 'auto-scale'

[xlbo]

Well, I guess that's pretty much it...

I have a pretty complicated report with lots of queries - most of which are interlinked via synchronisation. The data from these charts is sales by time and comes from 2 queries which are fully linked on all dimensions. They are also linked to the rest of the report on 2 items that are set as report sections.

Problem is that the 'auto-scale' setting on the charts is way off - seems to be basing the scale on the total sales value rather than the sales values for the section item...

any ideas ??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[blom0344]

Not really anything useful. Charts are not BO's forte. Building charts on data from synchronized dataproviders is finnicky..

Ties Blom

 

[xlbo]

no probs - will just muddle through as always with BOBJ !!!

cheers for responding

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[blom0344]

Geoff,

If you're familiar with the BCA could you look at my post on the BCA topic I posted today?

Ties Blom