Charts different data sources

A

André Fiuza

Hi,

My problem. I have a workbook with more than 50 worksheets. All the
worksheet have the same structure and each I would like to embed 3
different chart, one for income, other for cost and another for Ebitda.
I would like to make a template for each chart and copy for the others
worksheet.


Questions:


1 - How can I make this dynamic as I would like to choose hom many
months I would like to show in each chart?


2 - How I keep the reference for the data source in each worksheet?


I tried to use the functions offset, 3d range and others functions but
I could´t make them work.


Can somebody help me.


Thanks in advance,


Andre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Charts different data source 0
Embed the same Excel multiple times 0
Possible to Combine reports to's to a single box? 0
Charting a calculated number using the source data as the axis 1
One Chart, Same Data ranges, different source sheets 4
dynamic charts - problem with copy 3
Macro to change position of chart labels on line chart 1
Odd Chart Format Results 1

Top