Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default pivot table defaults to pivot chart

I want to set up the chart my own way rather than the way the pivot chart
does it. is there a way of turning off the automated pivot chart when I
click on the graph icon.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,979
Default pivot table defaults to pivot chart

In his article here, Jon Peltier describes how to make a regular chart
from pivot table data:

http://pubs.logicalexpressions.com/P...cle.asp?ID=553

billy_bags wrote:
I want to set up the chart my own way rather than the way the pivot chart
does it. is there a way of turning off the automated pivot chart when I
click on the graph icon.



--
Debra Dalgleish
Contextures
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
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot Table defaults for Excel 2007 HmE Excel Discussion (Misc queries) 2 March 7th 07 05:02 PM
function defaults change in Pivot Table..why? Jugglertwo Excel Discussion (Misc queries) 2 September 23rd 05 07:10 PM
Pivot table, summary function defaults WillD Excel Discussion (Misc queries) 1 June 10th 05 03:20 PM
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. Jersey Girl Excel Discussion (Misc queries) 1 March 10th 05 04:20 AM


All times are GMT +1. The time now is 03:29 PM.

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

About Us

"It's about Microsoft Excel"