Sorry, I didn't mean that the macro had to have the sheet's name hard coded
in order to work. I meant that the recorded macro has the first sheet's name
hard-coded in it, because recorded macros record exactly what you do. In my
post, I suggested changing the place in the macro with this hard coded sheet
name, something like

Worksheets("Sheet1")

to

ActiveSheet

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


"lisapizza" wrote in message
...


"Karen" wrote:

Thank you for your help - I'm not sure what you mean by "The macro must
have
the first sheet's name hard-coded in it." How should I do the
hard-coding?

This is what I have to do:
I click on each chart and go to Chart Source Data
Select the source data up to the current year
Then in the Source Data dialog box, I click the series tab and select the
Category (x) axis labels

Please help me with this - I have to have this done by Monday
Thank you


"Jon Peltier" wrote:

The macro must have the first sheet's name hard-coded in it. You can
change it to the active sheet:

For example, change this

Worksheets("Sheet1").Range("A1:B2")

or this

Worksheets(1).Range("A1:B2")

to this

ActiveSheet.Range("A1:B2")

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


Karen wrote:

Thank you for your help - I created the macro in the first sheet tab
and when
I run it for the 2nd tab, the 3rd tab and so on - It applies the data
from
the first tab. What am I doing wrong?

Thank you

"bj" wrote:


Record a macro changing the range in the charts in one sheet.
you may have to change it a little, but should able to just run the
macro
on each sheet to change all of the ranges.

"Karen" wrote:


I am using the following raw data for my line chart. In this case I
have 5
charts on each sheet tab. One for Bolts, one for Nuts and so on..
I also
have 25 sheet tabs for each customer. The way it's set up now is
that the
line chart only covers the data range of year 2002, 2003 & 2004.
When I want
to add each year I have to go into 5 charts on each tab and 25 tabs
for each
customer to select that data range. Initially, It should have been
set up to
highlight the data range up an until year 2008 so I could just plug
in the
numbers for each year and that data would populate the chart.
Should I just
go into each chart and each tab and highlight the data until 2008 or
is there
an easier way to do this so I don't have to do all that
highlighting?

Thank you, Karen

2002 2003 2004 2005 2006
2007
2008
Bolts 2145 2500 3245
Nuts 5214 5628 5487
Screws 526 650 698
Elbows 457 487 412
Nails 1248 1348 1578