Hi Jon and thank you for your response,
When I was creating all my pivot tables and charts based on the cell
reference table I had to have all the charts created before I started
creating a report as it was made from the scratch and even my boss didn't
exactley know what she wanted on the final report. Therefore, I needed all
sort of charts before placing their copies on to the report and manipulating
their order, place etc. My initial thought was, that once I had new sort of
data I would put new range in the originals and then copies would be updated
automatically as the originals are in the some workseets as tables so it is
easier to navigate. Now I think due to linking like problem I will be just
updating copies and abandon the originals. I wanted to automate the process
of doing this report and similar tables could be achieved by using in most
instances suproduct function with several conditions but even with pivot
tables that report was time consuming so didn't really consider formulas as
this would take much more time. Yet I think to give it a go and see how it
goes. I need this report to show invoicing in the company for different
businesses where we distict service A per country a b c... in months and
sometimes it just a service as total in the following months. So It looks
like a chart "service A-country a" and month Jan Feb...current month. Then I
show total for Service A in Jan.....current month. One report is for Head of
Depts and one collating everything for Heads of Division. I have over 100
charts so creating speparate tables was tiresome when using a formula that
worked but I had to amend little details which I didn't have to in pivots.
Additionaly I have to include tables that show, on top of graphs, paid,
unpaid invoices and their numbers, receivable days etc. but this easy. So
writing some VBA where my report is not static but changes (page breaks,
bigger, smaller invoicing tables (the easy ones) so I can't just aks somebody
to write a code that will replace/add data and correctly place everything
again and again. Possibly I wrong with this VBA nature as I just don't do VBA
at all.

Regards,
Piotr
I know this is a long story but hopefully this will give you better overview.

"Jon Peltier" wrote:

The question arises, why do you need two copies of the same chart?

There is a possible solution, which involves the Camera tool. This allows
you to take a picture of a range, and place the picture somewhere else. and
it will always be an up-to-date picture of the range, no matter how you
change it. Simply arrange the chart over a range, and use the camera to take
a picture of the range below the chart.

The camera tool has to be added to a toolbar somewhere. Right click on the
toolbar area and choose Customize. On the Commands tab, choose Tools in the
left list, then scroll 2/3 to the end of the right list, click on the Camera
tool, and drag it to a convenient place on a toolbar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com