Pivot chart

[mana]

hello,

i have a pivot chart in ms access and i want to have auto-axis for y-scale. I want that when the data will be changed the scale would be automatically arranged. can you help me? i don't know how to do this.
Thank you

 

[mana]

hello

can you help me please?
i can't see your message

 

[mana]

Hello

Can someone help me please?

I have A pivot chArt in access and I want auto scale for it
Thank youtk

 

[JHB]

Post you database with some sample data + the name of the form in which you've the problem. Also how to reproduce the "error"!

 

[mana]

hello

maybe i coudn't tell it correctly, i have a pivot chart and i want to have the auto scale in it. i mean i don't want to set the scales myself.
can you guide me please?

 

[JHB]

Please read post #4, else show some printscreen of what you've!

 

[mana]

Hello

i attached my chart

i want to have diferent scales in right and left side of the chart
thank you

 

[JHB]

Hmm - seems my other post disappeared.
Put in some "fake data", to displace the bars from each other, see below picture, (database attached).

 

[mana]

hi

thank you for the answer
i can't understand it completely
what do you mean with
Put in some "fake data"?

 

[JHB]

i can't understand it completely
what do you mean with
Put in some "fake data"?

Gap1 and Gap2 is the "fake data", they are only in to displace the bars from each other.

 

[mana]

i don't know in my example what i should do?
can you guide me please?

 

[JHB]

Could you post your database with some sample data?

 

[mana]

hello

this is some sample of my data but instead of id i have date in my database.

 

[mana]

and this data comes from a linked table in sql server

 

[mana]

hi

did you see my data?

 

[mana]

hi

did you see the data that i attached? do you have any ideas?

 

[JHB]

Yes, database attached.

 

[mana]

hi

thank you for the answer
it works now
do you know how i can make totals parameters invisible like you
becuase in totals my parameters are visible and i don't want to seee them
thank you

 

[JHB]

do you know how i can make totals parameters invisible like you
becuase in totals my parameters are visible and i don't want to seee them
thank you

What exactly do you mean?

By the way did you read my signature?

 

[mana]

thank you
i found it
thank you very very much for your help