Excel 2007 : Chart able to differentiate primary and secondary axis

Hi all,

I am trying to create an excel that is able to graph dynamically across multiple worksheet data into one chart. I have 3 Sheets(Graph, PrimaryData, SecondaryData).

The sheets("Graph"), will create a Line Chart which takes data from the sheet("PrimaryData") and plot into the primary axis.

Likewise the data from the sheet("SecondaryData") goes into the secondary axis.

Thanks in advance and hear from you soon!

Data from different sheets
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Dynamic charts
http://peltiertech.com/Excel/Charts/Dynamics.html

The simplest approach is to create a consolidated chart sourder from the disparate data sources.

I meant to type source.

No need for any code just use the named ranges. But rather than define the complete data source define the label and each data series separately.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

Dynamic ranges only control the starting point and/or the length of a data series.

If you want new series to appear you need to use VBA.

try using the search on .NewSeries

Hi Andy,

I have tried and tested using .NewSeries

Please Login or Register  to view this content.

however, this is not dynamic. how can I define it dynamically?

thanks once again !

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You can use the .End method to get the data range.

Please Login or Register  to view this content.

Hi Andy,

Apologized for not complying rule 3.

Using .End method is still not dynamic if I have new series to add. Is there a way if I could simply define a .SetSourceData method to get the data range to make the chart dynamic?

Maybe you would care to explain what you mean by dynamic?

As I have said, dynamic ranges can automatically extend existing chart series.
New chart series would require code to add the series. If the data it is to be based on can subsequently change in size then the reference needs to be a named range.