The new OpenOffice.org Charting Tool Coming in OpenOffice.org 2.3
For anyone who has grown weary of the current OpenOffice chart tool, or for anyone who has attended my classes and grown alarmed at hearing that charting is as much art as science, there is some relief in sight.
The chart tool has been improved significantly, and it's going to be included in OpenOffice.org 2.3, to be released roughly sometime this fall. If you're curious, you can download the developer version containing the chart tool here.
Here's a comment from Pete who appears to be involved in the chart development.
Thanks for the nice overview.
Please mentions also that many limitions will be overcome with the next
release. It's not only about a new (and shiny :) ) wizard. For example
multiple data series will be possible. Error bar for most kind of
charts will be possible. Regression lines with the function and R^2 are
implemented too. The performance regarding large data sets is improved.
EXCEL im- and export was improved considerably. Many of these features
are essential for engineers, students and scientists in their daily
job.
Worth to read:
http://graphics.openoffice.org/chart/whatsnewinchart2.html
However, there is still a long list of existing issues though OOo is
close to perfection. Any Volunteers will to finish the few remaining
items?
http://www.openoffice.org/issues/buglist.cgi?issue_type=DEFECT;issue_type=TASK;issue_type=PATCH;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=;chfieldfrom=;chfieldto=Now;chfieldvalue=;short_desc=;short_desc_type=substring;long_desc=;long_desc_type=substring;issue_file_loc=;issue_file_loc_type=substring;status_whiteboard=;status_whiteboard_type=substring;keywords=;keywords_type=anytokens;field0-0-0=component;type0-0-0=equals;value0-0-0=Chart;field0-0-1=short_desc;type0-0-1=substring;value0-0-1=chart;field0-1-0=short_desc;Submit%20query=Submit%20query&order=issues.issue_id
Here's a tour of it. I'm getting to know the details myself right now, but this is the gist. OK, a fairly detailed gist.
Here's the basic data we're working with.
I like to select the data since it means less typing, or just less dragging, later. Select the data and choose Insert > Chart. You get this. Click this and any other illustrations to see them bigger.
Window 1: Chart Type
Note that you get a preview of the chart as you go along, in the document. This preview of course disappears when you click Cancel without creating a chart.
There are more up front variations, it seems. Here are a few.
Who doesn't love an exploded donut?
Or a nice XY Scatter.
Or a Net.
A Column and Line with options for how many lines.
And here are the 3D options.
In this window you just pick a type, a variation, any associated options, and you click Next.
Window 2: Data Range
Here you get the choices for what data is involved. Normally in a simple chart you could just have A1 to D5 in a contiguous block. But when you don't have that, you get to specify that ahead of time. Not that this is new but it's more obvious and easier.
You could change the range just by typing something different in the Data Range field. In this, I skip the D column entirely. Use a semicolon to separate non-contiguous ranges of data.
You also have the option, again not new, to have the data in rows or in columns.
Rows
Columns
And you also get the options at the bottom of the window, First Row as Label and First Column as Label. This is the same kind of thing you specify when sorting; you're saying, if you check the box, that the first row is identifying data, not data to be charted, and ditto with the first column. You usually want to mark both. Or at least I do.
Here's what the chart looks like with both boxes marked.
And the same chart with both unmarked.
Click Next.
Window 3: Data Series
Here, you get even more control over exactly what cells are used for the labels (Names) and for the data (Y-Values). For instance, if you wanted the label for Sales to not be Sales but to be some other term off in cell J14, you could enter $J$14 instead in the Range for Name field shown.
Select Names, then select each of the items in the Data Series list and make changes if necessary for them in the Range for Name and Categories fields.
Then select Y-Values, and do the same thing for each item in the Data Series list.
If you want to add an entirely new set of data to the chart, just click Add. You'll get an Unnamed Series. Then set the Name and YValues for that one, too. Or click Remove to remove any chunk of data in the Data Series window from the chart.
Note that the Categories will be the same for all data series. If you change them for one item in the Data Series list, they'll change for all.
When done, click Next.
Window 4: Chart Elements
You're nearly there. This is the simple stuff.
Then click Finish. And you've got your chart.
Modifying the Chart Once It's Created
Modifying after creation is a tish less twitchy though not that fundamentally different.
One thing: used to be, you could just select the chart by clicking on it once, right-click, and choose to change the data series. Now you just need to double-click it, then right-click and choose Data Ranges.
Essentially, you double-click the chart, then either rightclick, use the Format menu, or use the Format toolbar. You can also double-click on an item in the chart.
The menu and toolbar have a fewer options, which will take getting used to but is a little simpler.
Here's the menu, and the toolbar after it.
To make a change to a particular bar in this chart, you do essentially the same thing as you used to. Double-click the chart, click on one of the bars to get the data series, then click on the specific bar to modify.
- Third click
- Fourth click
- Options under Object Properties (right-click, double-click, or use menu or toolbar)
- And results
To change titles, just double-click on them and type (after the requisite click, then double-click). This is the same as before.
Overall, not a makeover top to bottom. But nicer. I'm not a frequent chart user, so please give me your comments on what is the most useful.

















Thanks for the nice overview.
Please mentions also that many limitions will be overcome with the next release. It's not only about a new (and shiny :) ) wizard. For example multiple data series will be possible. Error bar for most kind of charts will be possible. Regression lines with the function and R^2 are implemented too. The performance regarding large data sets is improved. EXCEL im- and export was improved considerably. Many of these features are essential for engineers, students and scientists in their daily job.
Worth to read:
http://graphics.openoffice.org/chart/whatsnewinchart2.html
However, there is still a long list of existing issues though OOo is close to perfection. Any Volunteers will to finish the few remaining items?
http://www.openoffice.org/issues/buglist.cgi?issue_type=DEFECT;issue_type=TASK;issue_type=PATCH;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=;chfieldfrom=;chfieldto=Now;chfieldvalue=;short_desc=;short_desc_type=substring;long_desc=;long_desc_type=substring;issue_file_loc=;issue_file_loc_type=substring;status_whiteboard=;status_whiteboard_type=substring;keywords=;keywords_type=anytokens;field0-0-0=component;type0-0-0=equals;value0-0-0=Chart;field0-0-1=short_desc;type0-0-1=substring;value0-0-1=chart;field0-1-0=short_desc;Submit%20query=Submit%20query&order=issues.issue_id
Posted by: pete | June 05, 2007 at 08:18 AM
thanks for your sharing.sir!
so i share u some useful websites too.
http://www.buywowgold.org.cn wow gold|buy wow gold
http://www.buy-wow-gold.org.cn wow gold|buy wow gold
http://ggtop.nbatop.com google排名|google左侧排名
http://www.nbatop.com nba live|nba live 2008
Posted by: cool dog | October 21, 2007 at 06:48 AM
http://www.runescape2store.com
http://www.vgoldsupply.com
http://www.runescapemoney-runescapegold.cn
Posted by: runescape money | December 20, 2007 at 11:24 PM
I have found two interesting sources ( http://filesfinds.com & http://fileshunt.com ) and would like to give the benefit of my experience to you.
Posted by: Natasha | May 04, 2008 at 06:31 AM
http://www.aypearl.net/Html/Crystal_Jewelry/
http://www.aypearl.net/Html/Pearl_Jewelry/
http://www.aypearl.net
Posted by: Aypear | August 05, 2008 at 01:32 AM
I suggest a web http://www.bjbead.com
Posted by: BjBead | August 05, 2008 at 01:43 AM
fashion jewelry,jewelry wholesale,pearl jewelry,handmade jewelry, wholesale fashion jewelry,discount jewelry,wholesale crystal jewelry,gemstone jewelry,
Posted by: wholesale jewelry | September 15, 2008 at 01:23 AM
wholesale jewelry,jewelry store, crystal jewelry,jewelry wholesale,wholesale crystal
Posted by: fashion jewelry | September 27, 2008 at 01:08 AM
Lingerie Wholesale
Sexy Lingerie Wholesale
Leather/PVC Lingerie
Christmas Lingerie
Lingerie China
Posted by: Siman | October 16, 2008 at 03:42 AM
ffxi gil
Maple Story Mesos
wow gold
wow gold
a
buy Warhammer gold
Warhammer gold
Posted by: gbguh | October 28, 2008 at 10:40 PM
GOVERNOR BELLINGHAM, in adofus kamas loose gown and easy cap- much as elderly gentlemen loved to endue themselves with, in their domestic privacy-walked foremost, and appeared to be showing off his estate, and expatiating on his projected improvements. The wide circumference of an elaborate ruff, beneath his grey beard, in the antiquated fashion of King James'kamas dofus reign, caused his head to look not a little like that of John the Baptist in a charger. The impression made by his aspect, so rigid and severe, and frost-bitten with more than autumnal age, was hardly in keeping with the appliances of worldly enjoyment wherewith he had evidently done his utmost to surround himself. But it is an acheter kamaserror to suppose that our grave forefathers- though accustomed to speak and think of human existence as a state merely of trial and warfare, and though unfeignedly prepared to sacrifice goods and life at the behest of duty- made it a matter of conscience to reject such means of comfort, or even luxury, as lay fairly buy kamaswithin their grasp. This creed was never taught, for instance, by the venerable pastor, John Wilson,
Posted by: dofus kamas | November 10, 2008 at 05:29 AM
During the night of the 5th of December, the train ran south-easterly for about fifty miles; then rose an equal distance in a north-easterly direction, towards the Great Salt Lake.
Passepartout, about nine o'clock, went wow goldout upon the platform to take the air. The weather was cold, the heavens gray, but it was not snowing. The sun's disc, enlarged by the mist, seemed an enormous ring of gold, and Passepartout was amusing himself by calculating its value in pounds sterling, when he was diverted from this interesting study by a strange-looking personage who made his appearance on the platform.
Posted by: wow gold | November 10, 2008 at 05:30 AM
ELIZABETH was wow gold sitting by herself the next morning, and writing to Jane, while Mrs. Collins and Maria were gone on business into the village, when she was startled by a ring at the door, the certain signal of a visitor. As she had heard no carriage, she thought it not unlikely to be Lady Catherine, and under that apprehension was putting awaywow gold her half-finished letter that she might escape all impertinent questions, when the door opened, and to her very great surprise, Mr. Darcy, and Mr. Darcy only, entered the room. He seemed astonished too on finding her alone,wow gold and apologised for his intrusion by letting her know that he had understood all the ladies to be within. They then sat down, and when her enquiries after Rosings were made, seemed in danger of sinking into total silence. It was wow goldabsolutely necessary, therefore, to think of something, and in this emergency recollecting when she had seen him last in Hertfordshire, and feeling curious to know what he would say on the subject of their hasty departure, she observed, "How very suddenly you all quitted Netherfield last November, Mr. Darcy! It must have been a most agreeable surprise to Mr. Bingley to see you all after him so soon; for, if I recollect right,wow gold he went but the day before. He and his sisters were well, I hope, when you left London."
Posted by: wow gold | November 10, 2008 at 05:32 AM
thanks for http://www.batterylaptoppower.com
Posted by: batteries | November 10, 2008 at 11:32 PM
thanks for http://www.batterylaptoppower.com
Posted by: batteries | November 10, 2008 at 11:32 PM
http://www.kelebeklove.com thanks for.
Posted by: kelebek | November 22, 2008 at 12:59 AM
It’s no doubt that handbag have been one of the must-have necessity of life for people ever since recorded history began. It's a sign of taste and fashion, as well as a symbol of social status and recognition. Recently, replica handbags are gaining worldwide popularity. There are millions who wish to own a real designer bag but cannot afford to do so. This is because the original designer handbags are very expensive. Thus, the replica handbags have taken the world market of handbags completely by storm and are in great demand. We present you a great number of replica handbags including Louis Vuitton, Gucci, Prada, Hermes, Chloé, Christian Dior and any other luxury ones. If you are shopping for
http://www.exacthandbag.com
http://www.idolreplicas.com
an affordable handbag, then just feel free browse our selection to find the perfect item for yourself or to be given as a gift. All of these replica handbags we provide are virtually indistinguishable from the authentic ones. Improve your lifestyle now! Enjoy your purchase of replica handbags on exacthandbag.com.
Posted by: McLean | November 26, 2008 at 01:32 AM
Actually, almost all electronic device manufacturers do not produce the batteries used in the devices. They all have to be manufactured by outside battery manufacturers. Therefore, there's no difference in turns of quality and reliability. Our aim to provide the best quality and high-performance batteries to our customers, we have adjusted the batteries' internal resistance for more stable and more reliable. As a result, there will be a little bit difference in our batteries run-time comparing with the OEM batteries' (no more than 10%).
http://www.laptops-batteries.net
http://www.laptopbatterystore.co.uk
Posted by: jerry | November 26, 2008 at 01:34 AM
louis vuitton designer handbags paradise http://www.replicaestore.com
Posted by: Louis vuitton | December 05, 2008 at 11:28 PM
The new OpenOffice.org Charting Tool Coming in OpenOffice.org 2.3.this tools performace how.
www.top-laptopbattery.com
Posted by: laptop battery | December 08, 2008 at 12:56 PM
As we know, wow gold guide,buying wow gold
Posted by: wow gold guide | December 17, 2008 at 02:37 AM
I have never used open office at all yet, but I'll be sure and bookmark this page as I'm hoping to use it soon.
Posted by: massachusetts water damage | December 17, 2008 at 12:15 PM
A new perspective into all the people of wow gold series of more than a new name, World of Warcraft, we have 24 / 7 service for buy wow gold, we will let you enjoy the fun of cheap wow gold,wow power leveling,wow gold ,buy wow gold and wow power leveling.We hope you enjoy your wow gold to bring you happiness.
Posted by: cqx | December 19, 2008 at 02:13 AM
wow goldness this is not spam please let it og through now
Posted by: wow gold | December 23, 2008 at 06:37 PM
thanks for sharing :)
Posted by: lovelouisvuitton | December 24, 2008 at 03:04 AM