Data Range Mess

"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
> > >>>
> >

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" <lisapizza@discussions.microsoft.com> wrote in message
news:1B3CAF6B-F602-4566-BC8A-55538214296A@microsoft.com...
>
>
> "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
>> > >>>
>> >