> TomW wrote: > I played around with the formatting on this issue and was able to > generate a format 1.0 , 1.5, etc. without resorting to a new column. > The format code is: #\.#,, > The "B" for billion (or "Billion") would have to be added to the axis > title. This can be set within the chart if you break the link to the > data for the Y-axis by un-checking the source format. >
Thanks Tom, I tried it as soon as I saw your post. Didn't work for me but that is on Ubuntu 6.06 LTS with OOo 2.0. I'll try it again later on another computer with XP Pro and OOo 2.3. Maybe it will work there. Hope so. On what OS and OOo version is it working for you?
