Issue 43460

requirements

If you are asking for requirements, the interface should be drag and drop in
nature, whether adding elements or using them.  All datapilot columns/datatypes
would appear as a drop-down menu with an empty chart area, defaulted to columns,
for example.  I should be able to take any element and drop it below the X-axis,
and Viola!  It becomes the X-axis.  Any element I drop in the chart area is then
put on the Y-axis and added to the legend.  I should be able to mix, drop, alter
this in any way without having to click the Save button at any time.  Once I
have the chart I want from my Datapilot data, I should be able to export the
chart as an OLE object and/or a graphic file.

This functionality does exist in a famous commercial office suite. It's needed
to pretend OOo has the same level of functionality.
Furthermore, it's very useful if you use the DataPilot in general : if your
table is huge, it's unreadable and only a "linked graph" can help (I mean, a
graph that knows it's working on the DataPilot and thus can add/remove fields).

I forgot : still needed in OOo 2.x (including 2.1)

This overlaps with issue 14506.

Our entire enterprise has just discontinued usage of the other office products, and we now are forced to use a bundled up version of openoffice ( osgi type stuff ) called Symphony or openoffice directly. I am not an early adopter, I did not seek out OpenOffice, I have no 'brand loyalty'. All I know is that my old spreadsheets with data tables don't produce my quarterly charts any more....I am going to have to go and buy a license for the other office suite, or redo them all with some DB approach. I am not happy about that ....

I believe you guys are starting to replace the other office suite more and more in business, but the replacement probably won't be permanent with our group...

Thanks for the otherwise good product....

Even if there isn't a dynamic chart-based interface to pivot tables, is there perhaps a workaround of producing a chart based on pivot table data? My attempts (stacked column) are useless. Producing a chart from pivot table data seems a fairly basic requirement.

(In reply to andrew_g_scott from comment #7)
> Even if there isn't a dynamic chart-based interface to pivot tables, is
> there perhaps a workaround of producing a chart based on pivot table data?
> My attempts (stacked column) are useless. Producing a chart from pivot table
> data seems a fairly basic requirement.

Actually, I'll retract this comment. I've been playing around a bit more with pivot tables and stacked column charts and I've managed to come up with something that's passable for my purposes at least.