LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Having different Y-axis

Hi,
Greetings.

I have 10 sets of data (i.e, 10 series). I have to plot this data with
two different Y-axis types: left side with StackedColumn and right sie
with StackedColumn100 types.

For this first I have plotted all the data. Created one dummy series
(i.e. 11th series) whose values (both x and y) are zero and set it as
secondary axis. Now when I try to set its' 'Type' property with
xlColumnStacked100 it throws exception. (I can not set 'ChartType'
property of this dummy series,; because setting this property will
change all the series objects chart type).

Can somebody help me how to do this?

Thanks in advance

Cheers
Ara

 
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
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) Holger Gerths Charts and Charting in Excel 8 June 5th 08 04:25 PM
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 10:27 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"