Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
MrN MrN is offline
external usenet poster
 
Posts: 1
Default Cannot change data source for copied charts

I think it is a bug in Excel 2007. Otherwise, if someone has a solution I'd
be happy to hear that ;-)

Here is the problem:
I got a table with lots of data. In order to extract the relevant
information I inserted a pivot table. Then I wanted to display the extracted
information within a chart. For that, I marked the pivot table and inserted a
3D block chart.
Now, I wanted to modify the pivot extraction a little bit and I'd like to
see the result of my modification inside the chart. As long as I do it in the
original pivot table everything works fine.
Now, the problem comes: I'd like to permanently keep both pivot extractions
inside the workbook. Therefore, I copied the sheet containing the pivot table
and the chart to a second sheet. Now, I have 3 sheets inde the workbook: the
original data sheet, the 1st pivot sheet and the copied pivot sheet.
At first I recognized that the chart in the copied pivot sheet always refers
to the data inside the 1st pivot sheet. The problem is now, when I try to
change the data source ("select data source" -- "chart data range") I see
that the input field is greyed out. So, I cannot change the data source of
the chart in the copied sheet.
The only possibility I found is to delete the chart in the copied sheet an
to create it completely new from scratch based on the pivot table of the
copied sheet.

Any ideas?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Cannot change data source for copied charts

You cannot change the data source of a pivot chart. It points to the
original pivot table, and that's that. But you can try to work around this
issue.

Save the sheet with the pivot table and chart as a new workbook with a
different name. Reopen the original workbook, then open the saved-as
workbook, and move the sheet into the original workbook. This gives you two
pivot tables, one each with its own chart. Repeat opening the saved-as
workbook and moving it into the main workbook as required.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"MrN" wrote in message
...
I think it is a bug in Excel 2007. Otherwise, if someone has a solution I'd
be happy to hear that ;-)

Here is the problem:
I got a table with lots of data. In order to extract the relevant
information I inserted a pivot table. Then I wanted to display the
extracted
information within a chart. For that, I marked the pivot table and
inserted a
3D block chart.
Now, I wanted to modify the pivot extraction a little bit and I'd like to
see the result of my modification inside the chart. As long as I do it in
the
original pivot table everything works fine.
Now, the problem comes: I'd like to permanently keep both pivot
extractions
inside the workbook. Therefore, I copied the sheet containing the pivot
table
and the chart to a second sheet. Now, I have 3 sheets inde the workbook:
the
original data sheet, the 1st pivot sheet and the copied pivot sheet.
At first I recognized that the chart in the copied pivot sheet always
refers
to the data inside the 1st pivot sheet. The problem is now, when I try to
change the data source ("select data source" -- "chart data range") I see
that the input field is greyed out. So, I cannot change the data source of
the chart in the copied sheet.
The only possibility I found is to delete the chart in the copied sheet an
to create it completely new from scratch based on the pivot table of the
copied sheet.

Any ideas?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using time data copied and pasted into excel from external source Ravi B Excel Discussion (Misc queries) 4 February 9th 09 03:35 PM
change source data in multiple charts Tuxla Charts and Charting in Excel 5 September 4th 08 03:38 PM
Named-range source-data for pie charts on copied worksheets [email protected] Charts and Charting in Excel 4 March 19th 07 06:50 AM
How do I create charts that change source data automatically? cbalster Charts and Charting in Excel 0 May 26th 06 08:19 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 06:19 PM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"