Test values in data table?

F

Fred Smith

I'm printing a data table with my graph. I want to calculate a font which
displays all numbers as large as possible, without overflowing any cell (ie,
no '#####').

Currently I calculate the font as:

..DataTable.Font.Size = 14 - lr / 2

where lr is the number of categories printed. It works very well for most
data.

However, when I have a graph where all numbers are small (eg, no number
great than 1,000,000), I could safely increase the font size without any
overflow.

Is it possible to access the Datatable cells in a formula, as in:

if max(data table cells) < 1000000 then ...

?
 
Top