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.

Read more
Download

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.

---

---

Comments

[pete]

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

[cool dog]

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

[runescape money]

http://www.runescape2store.com
http://www.vgoldsupply.com
http://www.runescapemoney-runescapegold.cn

[Natasha]

I have found two interesting sources ( http://filesfinds.com & http://fileshunt.com ) and would like to give the benefit of my experience to you.

[Aypear]

http://www.aypearl.net/Html/Crystal_Jewelry/
http://www.aypearl.net/Html/Pearl_Jewelry/
http://www.aypearl.net

[BjBead]

I suggest a web http://www.bjbead.com

[wholesale jewelry]

fashion jewelry,jewelry wholesale,pearl jewelry,handmade jewelry, wholesale fashion jewelry,discount jewelry,wholesale crystal jewelry,gemstone jewelry,

[fashion jewelry]

wholesale jewelry,jewelry store, crystal jewelry,jewelry wholesale,wholesale crystal

[Siman]

Lingerie Wholesale
Sexy Lingerie Wholesale
Leather/PVC Lingerie
Christmas Lingerie
Lingerie China

[gbguh]

ffxi gil
Maple Story Mesos
wow gold
wow gold
a
buy Warhammer gold
Warhammer gold

[dofus kamas]

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,

[wow gold]

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.

[wow gold]

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."

[batteries]

thanks for http://www.batterylaptoppower.com

[batteries]

thanks for http://www.batterylaptoppower.com

[kelebek]

http://www.kelebeklove.com thanks for.

[McLean]

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.

[jerry]

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

[Louis vuitton]

louis vuitton designer handbags paradise http://www.replicaestore.com

[laptop battery]

The new OpenOffice.org Charting Tool Coming in OpenOffice.org 2.3.this tools performace how.
www.top-laptopbattery.com

[wow gold guide]

As we know, wow gold guide,buying wow gold

[massachusetts water damage]

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.

[cqx]

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.

[wow gold]

wow goldness this is not spam please let it og through now

[lovelouisvuitton]

thanks for sharing ：）