Graphs & Data range

[Lynn]

Excel 2000

I have created a stacked column graph to plot data over 52
weeks. The x axis is hours and the y axis is weeks. The
graph is an objectin a worksheet. I want to save the
graph weekly in separate worksheets within the same
workbook i.e. wk 2 worksheet will graph data for weeks 1
and 2. Wk 3 worksheet will graph data for weeks 1-3 and so
on.

The only problem I have is that as I am adding data week
by week to my data range all the graphs are changing
accordingly. There must be a way to stop this happening.
Can anyone help.

Thanks
Lynn

 

[Jon Peltier]

Lynn -

Does your chart get its data from a range which contains running totals?
Excel's charts are dynamic, so that they change when the values in the
source data cells change.

Make sure your charts link to the cells you think they are linking to.
It would not be hard to have a sheet with certain data, and your chart
actually links to a different sheet, so that the data in the sheet is
static, but the chart keeps changing. Go to Source Data on the Chart
menu, select the Series tab, and see what range is indicated.

Of course, you could unlink the chart from its worksheet data:
http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

- Jon

 

[Tushar Mehta]

One way would be to create an image of the chart. Click on the chart,
then select SHIFT+Edit | Copy Picture... and follow instructions to
place an image of the current chart wherever you want.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions