I'm trying to record a macro that creates a chart from a given set of a data.
When I record the macro in a workbook and attempt to run the macro in another
workbook, I get a reference error. Is there a way to get around this?

When I go to the series tab of the chart, excel is referencing the current
workbook's sheet name for X and Y values. I want excel to reference any new
sheet from any new workbook that I open.

Chris napisal(a):
I'm trying to record a macro that creates a chart from a given set of a data.
When I record the macro in a workbook and attempt to run the macro in another
workbook, I get a reference error. Is there a way to get around this?

When I go to the series tab of the chart, excel is referencing the current
workbook's sheet name for X and Y values. I want excel to reference any new
sheet from any new workbook that I open.

see
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
mcg

That link teaches you how to edit a chart with VB, I haven't learned VB yet
so is there a simple way to just make the change in Excel?

"mcg" wrote:


Chris napisal(a):
I'm trying to record a macro that creates a chart from a given set of a data.
When I record the macro in a workbook and attempt to run the macro in another
workbook, I get a reference error. Is there a way to get around this?

When I go to the series tab of the chart, excel is referencing the current
workbook's sheet name for X and Y values. I want excel to reference any new
sheet from any new workbook that I open.

see
http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
mcg

Modify your code to refer to the activesheet.

--
Regards,
Tom Ogilvy


"Chris" wrote:

I'm trying to record a macro that creates a chart from a given set of a data.
When I record the macro in a workbook and attempt to run the macro in another
workbook, I get a reference error. Is there a way to get around this?

When I go to the series tab of the chart, excel is referencing the current
workbook's sheet name for X and Y values. I want excel to reference any new
sheet from any new workbook that I open.

I don't know how to do that

"Tom Ogilvy" wrote:

Modify your code to refer to the activesheet.

--
Regards,
Tom Ogilvy


"Chris" wrote:

I'm trying to record a macro that creates a chart from a given set of a data.
When I record the macro in a workbook and attempt to run the macro in another
workbook, I get a reference error. Is there a way to get around this?

When I go to the series tab of the chart, excel is referencing the current
workbook's sheet name for X and Y values. I want excel to reference any new
sheet from any new workbook that I open.