Issue 14506 - Convert MS PivotChart to DataPilot Chart
Summary: Convert MS PivotChart to DataPilot Chart
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 18 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, rfe_eval_ok
: 17453 98534 125862 (view as issue list)
Depends on:
Reported: 2003-05-16 01:17 UTC by mjneedles
Modified: 2015-05-10 19:13 UTC (History)
15 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Excel Workbook with a pivot chart on one Sheet based on a pivot table on another sheet (26.00 KB, application/msexcell)
2003-05-16 01:27 UTC, mjneedles
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mjneedles 2003-05-16 01:17:22 UTC
I request the addition (soon) of pivot charts for Calc.  Opening an Excel sheet 
of a pivot chart displays a meaningless chart with no data plotted.

Attachment will follow.

Matt Needles
Comment 1 mjneedles 2003-05-16 01:27:37 UTC
Created attachment 6218 [details]
Excel Workbook with a pivot chart on one Sheet based on a pivot table on another sheet
Comment 2 kla 2003-05-28 11:24:42 UTC
Hi Bettina,
one for you.
Comment 3 oc 2003-07-28 09:48:48 UTC
*** Issue 17453 has been marked as a duplicate of this issue. ***
Comment 4 bettina.haberer 2003-10-15 16:09:35 UTC
Hello, Björn. As this concerns the interoperability, I suggest it for
OO.o 2.0. But you will see.
Please give approval for this evaluated OO.o 2.0 flagged issue. 
If you confirm with the target OO.o 2.0, then please keep it on your
owner (or the owner of the concerning developer) for implementation.
In case you want this issue for 'OOo Later', then please reset the
target milestone. If you decline the issue finally, please set the
resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or
'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 5 bjoern.milcke 2003-10-15 17:24:32 UTC
The implementation of pivot charts is a quite complex task.  As our
schedule for OOo 2.0 is already rather tight, I will postpone this
after the release of 2.0.
Comment 6 okapi1253 2004-02-18 02:47:04 UTC
The issue does occur for me as well.
Comment 7 bettina.haberer 2004-11-29 18:15:03 UTC
Reassigned to Ingrid.
Comment 8 stp 2005-03-06 18:44:03 UTC
Rewrote summary since issue is about converting PivotCharts to DataPilot charts.
DataPilot is similar to PivotChart and DataPilot is an existing feature.
Comment 9 IngridvdM 2005-04-15 12:49:45 UTC
Comment 10 stp 2005-04-22 21:08:39 UTC
Issue 4077 could be set as a duplicate of this (or vice versa). I recommend
keeping this issue as it is described better than in 4077.
Comment 11 IngridvdM 2005-04-25 10:37:42 UTC
->thing: No, the issues are not duplicate. Issue 4077 is about what the calc has
to do and this Issue 14506 is about what the chart has to do. See the component
field of both Issues. Thanks.
Comment 12 mjneedles 2006-06-14 15:02:26 UTC
Cannot this be closed, as this is working fine now?
Comment 13 IngridvdM 2006-06-28 15:41:05 UTC
->mjneedles: Using one of the latest milestones (SRC680m172) the bug still
occurs for me. The chart on the second page is still empty. Which version did
you use?
Comment 14 mjneedles 2006-06-29 05:25:52 UTC
I just tested the file again on _m173, and got the same results as when first
tested.  The Pivot Chart function does not work yet.  Also, the Data Pilot
(Pivot Table function in OOo) does not look as nice or complete as Excel's.  For
example, when this workbook is opened in Excel (XP), the source table for the
Pivot Table has the source data selected with a gray background, making it plain
that the pivot table is based on that part of the table.  Calc does not do that,
rather, it leaves no visual indication of what part of the table was used to
create the pivot table.
Comment 15 IngridvdM 2006-06-29 09:50:42 UTC
->mjneedles: Thanks for the fast response! I would like to have this issue about
the wrong chart only. Could you please write another issue for the missing
selection in calc to nn. Thanks a lot.
Comment 16 pagalmes.lists 2007-07-30 12:01:18 UTC
I think that issue 43460 is a duplicate from this one. Can someone confirm it
and then close the issue accordingly?
Comment 17 IngridvdM 2007-07-30 12:19:50 UTC
No, it is not duplicate. This one is about displaying charts on pivot tables,
the other one is about manipulating pivot tables via chart interface.
Comment 18 jbasc19921jbkas 2008-03-20 19:41:05 UTC
"DataPilot is similar to PivotChart and DataPilot is an existing feature."
I disagree! What I really want is a genuine DataPilotChart i.e. one that
displays the results of a DataPilot not just the cells which it currently
occupies i.e. if I refresh the DataPilot and it now has extra columns (e.g. for
data for a new month) the chart needs to automatically refresh also to include
the data in these new cells?
Comment 19 jmason_yamato 2008-05-23 18:31:48 UTC
OS and Platform chould be change to 'All', as this enhancement remedies a
feature missing in all OOo platforms.
Comment 20 IngridvdM 2008-06-02 12:17:18 UTC
changed OS and platform
Comment 21 jmason_yamato 2008-06-02 17:28:48 UTC
Thanks, Ingrid. So, how about changing the Target milestone to OOo 3.1 ?
Comment 22 IngridvdM 2008-07-22 14:20:38 UTC
reset to new
Comment 23 kyoshida 2009-01-30 02:54:04 UTC
*** Issue 98534 has been marked as a duplicate of this issue. ***
Comment 24 ohallot 2009-06-29 19:39:57 UTC
cc'ing myself.

Pivot charts are a must-have.
Comment 25 yohana22 2009-07-23 14:49:54 UTC
We’ve tried version 3.1 and the error is still in there. 
Comment 26 yohana22 2010-03-25 16:45:52 UTC
We’ve tried version 3.2 and the error is still in there.
Comment 27 oooforum (fr) 2014-11-17 10:34:36 UTC
*** Issue 125862 has been marked as a duplicate of this issue. ***
Comment 28 Doug Camens 2015-05-10 19:13:25 UTC
I have OpenOffice 4.1.1 and it looks like pivot charts are still not supported. I tried to create a normal chart on the pivot table data and the chart is not very readable.  Pivot chart would be a valuable enhancement for OO.