LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Rav99
 
Posts: n/a
Default Pivot Chart - default chart type

I created a Pivot chart from Pivot table, however, as the user changes the
options (from pivot fields), then the chart type changes back to default one
(I want the line-column 2 axes one). I figured I could go to VBA properties
to default the chart type by choosing the chart code, however under that
list, there is no chart code for that combination chart (line chart + column
chart with 2 axes). How can I do this?

Can someone help... as I am not good at VBA? Thanks!
 
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
Setting and KEEPING the default chart redbelly Charts and Charting in Excel 0 June 30th 05 02:35 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
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
How do I create a custom scroll bar on a 3D Pivot Chart? JRW in Idaho Charts and Charting in Excel 1 December 1st 04 08:55 PM


All times are GMT +1. The time now is 05:54 AM.

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"