Overlaying multiple transparent charts

Tom Schreiner · Jan 14th, 2002, 06:21 PM

Hi
I'm not too sure if this will help you or not, but try positioning you charts after you change the values.

Also in chart area properties, choose "Do not move or size with cells"

Don't know if that is relevent or not.

YourChart1.ChartArea.Left = value
YourChart1.ChartArea.Top = value
YourChart1.ChartArea.Height = value

YourChart1.PlotArea.Left = value
YourChart1.PlotArea.Top = value
YourChart1.PlotArea.Height = value

Tom

[ This Message was edited by: TsTom on 2002-01-14 17:22 ]

mmhoballah · Apr 14th, 2002, 07:46 AM

I need to place several transparent charts on top of each other with both axes aligned exactly. I can do this manually once, but if I add new data (using a macro), relative chart locations move. Is there a way to make both chartarea and plotarea fixed in both size and location?
thank you

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jan 14th, 2002, 06:21 PM	#1
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi I'm not too sure if this will help you or not, but try positioning you charts after you change the values. Also in chart area properties, choose "Do not move or size with cells" Don't know if that is relevent or not. YourChart1.ChartArea.Left = value YourChart1.ChartArea.Top = value YourChart1.ChartArea.Height = value YourChart1.PlotArea.Left = value YourChart1.PlotArea.Top = value YourChart1.PlotArea.Height = value Tom [ This Message was edited by: TsTom on 2002-01-14 17:22 ]

Apr 14th, 2002, 07:46 AM	#2
mmhoballah New Member Join Date: Apr 2002 Posts: 3	I need to place several transparent charts on top of each other with both axes aligned exactly. I can do this manually once, but if I add new data (using a macro), relative chart locations move. Is there a way to make both chartarea and plotarea fixed in both size and location? thank you