Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default pivottable + chart

How to add data to the chart of a pivottable but the data are not in the
datasource of the pivottable

Regards
Franck


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default pivottable + chart

Hi
AFAIK this is not possible for these kind of pivot charts

--
Regards
Frank Kabel
Frankfurt, Germany


Franck wrote:
How to add data to the chart of a pivottable but the data are not in
the datasource of the pivottable

Regards
Franck

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default pivottable + chart

Thanks Frank Kabel

Is there another way to do it by using another kind of charts

"Frank Kabel" a écrit dans le message de
...
Hi
AFAIK this is not possible for these kind of pivot charts

--
Regards
Frank Kabel
Frankfurt, Germany


Franck wrote:
How to add data to the chart of a pivottable but the data are not in
the datasource of the pivottable

Regards
Franck



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,979
Default pivottable + chart

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm

Once you've created the normal chart, you could add your other data to
that chart.

Franck wrote:
Thanks Frank Kabel

Is there another way to do it by using another kind of charts

"Frank Kabel" a écrit dans le message de
...

Hi
AFAIK this is not possible for these kind of pivot charts

--
Regards
Frank Kabel
Frankfurt, Germany


Franck wrote:

How to add data to the chart of a pivottable but the data are not in
the datasource of the pivottable

Regards
Franck






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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
Where are the pivottable chart buttons? Jelmer Charts and Charting in Excel 8 May 25th 10 02:38 PM
Standard Chart from PivotTable ? H.G. Lamy Charts and Charting in Excel 0 December 17th 09 10:38 AM
PivotTable and Chart Michael Excel Discussion (Misc queries) 0 August 3rd 06 06:57 PM
XY-chart with pivottable? SvenM Excel Discussion (Misc queries) 1 April 12th 06 01:17 PM
Update Chart in Pivottable Tobias[_2_] Excel Programming 1 April 27th 04 12:56 PM


All times are GMT +1. The time now is 09:58 PM.

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"