Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-08-2009
Member
 
Join Date: Dec 2008
Posts: 112
How to get Pivot chart title and VBA

I have number of records and multiple field in my Excel sheet, from that i have set some primary fields and the others are non-primary, Now I wanted to take a Dynamic Chart using Pivot Table and VBA as per my records and other related data. Is it possible to change chart automatically. Thanks for your help.
Reply With Quote
  #2  
Old 13-08-2009
Member
 
Join Date: Feb 2006
Posts: 167
Re: How to get Pivot chart title and VBA

In Using Pivot Table Data for a Chart with a Dual Category Axis, I showed how to make a Chart with a Dual Category Axis using a pivot table to properly arrange the source data. Right click on the sheet name tab of the sheet housing the PivotTable and choose View Code. In here paste the code below and modify Chart1 to suit.
Reply With Quote
  #3  
Old 13-08-2009
Member
 
Join Date: Feb 2006
Posts: 185
Re: How to get Pivot chart title and VBA

Normally the Title is already centered. I can't find a way of programmatically centering the Title because it does not have a Width property. A PivotChart view uses the Office Chart Component and helps you create dynamic, interactive charts. The views support interactions, such as adding, filtering, and sorting data, without you having to write code.
Reply With Quote
  #4  
Old 13-08-2009
Member
 
Join Date: Oct 2008
Posts: 127
Re: How to get Pivot chart title and VBA

you need to write code. This article presents sample code for performing simple tasks, such as moving and filtering fields, in PivotTable and PivotChart views. I generally prefer using a regular chart, because pivot charts are pretty inflexible when it comes to formatting. Unfortunately, a regular chart doesn?t know when the pivot table has been resized by a refresh.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to get Pivot chart title and VBA"
Thread Thread Starter Forum Replies Last Post
How to add subtitles to chart title in Excel Lanka Boy Windows Software 1 07-01-2012 05:49 PM
how to create a gantt chart from a pert chart ? Loeb Microsoft Project 5 08-07-2011 10:24 AM
How to Create, edit or delete an array formula or Pivot Chart agarwalm11 Guides & Tutorials 1 31-12-2009 12:22 PM
Difference between title tag and <meta name="title"> Indrani Software Development 3 19-05-2009 04:22 PM
How to export Pivot Chart from Access to ppt Kurtz Software Development 2 18-05-2009 10:52 AM


All times are GMT +5.5. The time now is 03:47 AM.