Copying a worksheet with charts

[TNapp]

Hi There,
I have a worksheet with quite a lot of charts in it. I have created multiple copies of the worksheet (by right-clicking on the tab) each with new data but in exactly the same cells. The charts have all updated to reference to each new worksheet that they are in BUT the x-axis does not update correctly. It becomes an additional series rather than remaining as the x-axis. These are all 'column charts' whilst the 'line chart' updates correctly. Is this a 'bug'?
Thanks,

Tamaryn

 

[Andrew Poulsom]

Can you give some sample source data for one of the column charts?

 

[TNapp]

Is there a way that I can attached an excel file here?
The column charts are stacked column charts with years in the first row (the x-axis) and then the rows after contain the data for the series which make up the stacks.

	2005	2006	2007	2008	2009
coal
gas
oil
electricity

<tbody>
</tbody>

 

[Andrew Poulsom]

You can put your workbook on a share like Box.com and post the URL.