bar chart expresssion

[zezo2021]

hello friends
this code is used with a query to create a bar chart in the query the problem is with big number need column to be wider how can I fix this problem

TheGraph: String(CInt([Population]),ChrW(9600))

 

[arnelgp]

use "percentage" of the Area to fill?

say you have a reference there, a Label control for example, with Y height.
to put a percentage of your [population] against Y height:

TheGragph: String(Y * [population] / [total population], ChrW$(9600))

 

[zezo2021]

use "percentage" of the Area to fill?

say you have a reference there, a Label control for example, with Y height.
to put a percentage of your [population] against Y height:

TheGragph: String(Y * [population] / [total population], ChrW$(9600))

Not understand (Y)

 

[arnelgp]

look at this demo.
see the formula of the graph textbox.
it needs 20 ChrW$(9600) character to fully "fill" the graph.

 

[zezo2021]

look at this demo.
see the formula of the graph textbox.
it needs 20 ChrW$(9600) character to fully "fill" the graph.

GOOD EXAMPLE

BUT SHOULD I GUESS THE NUMBER 20

 

[arnelgp]

BUT SHOULD I GUESS THE NUMBER 20

You designed the report, therefore you should know how much char will the "graph" be filled.