Using DataBars from Macro

[Alvin2]

Hi All,
Despite a careful search I didn't find anything in the web that could explain how to manage DataBars from CalcBasic macros.
I also tried to figure out something using the macro recorder, but it also didn't help.
I have some single column tables that I periodically create from scratch and sort using macros.
To better grab the meaning of the tables I use the DataBars, that usually I set manually. That's cumbersome, so I'm trying to set
databars programmatically, but, at present, have no idea on how to achieve it.
Of course I also looked into Pitonyak "Bible", no way.
Please can someone address me to a suitable reading or, better, show me some practical example?
Best Regards
Alvin2

[F3K Total]

Hello,
send one of your files that you periodically create from scratch and sort using macros, and one .ods with manually set databars as you like to have them.
Maybe https://wiki.openoffice.org/wiki/MediaW ... e_-_Charts helps
or http://www.openoffice.org/api/basic/man ... torial.pdf page78 ff. 4.4.3.1 Creating barcharts
Find also attached an example.
R

[Lupp]

I have some single column{emphasis by Lupp} tables that I periodically create from scratch...

What is your question about:
-1- Bar Charts?
-2- The 'Data Bar' variant of the 'All cells' mode of ConditionalFormatting?

[AndresSolar]

I use a custom font (FastBar) and a simple cell-formula to scale to % for the same purpose.
Very fast - and simple to manipulate via macro. Works on single cells and ranges and enables conditional formatting (color limits, etc.)