Macro in Microsoft Excel

Posted Date: 29 Oct 2009 Posted By: mangaiyarkkarasi.b Member Level: Silver Points: 1 Responses: 1

I coded in Macro to get charts by Charts.Add method and setdata source by dynamically
I have two tables in single sheet whicy dynamically increace row by weekly.
According to that i add charts by deleting old charts every time macro runs.
I got everything.
But the thing is I used ActiveCharts.SetDatasource. So i got the graph lines for only 2nd chart which is activate latest. I don't get the map lines for 1st chart which is blank.
Is there any chance to get activate 2 charts in single sheet.
Can anyone help me please.
Thanks in Advance

Responses

Author: Sudeep Syamnath 11 Nov 2009

Member Level: Silver

Rating:

Points: 2

Hello mangaiyarkkarasi,

You can active the charts one by one and then set the datasource for it.

Best Regards,
Sudeep Syamnath

Post Reply

You must Sign In to post a response.

	Next : Macro in Microsoft Excel
	Previous : How to change language display
	Return to Discussion Forum
	Post New Message
	Category: Microsoft Dynamics

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use