Changing Multiple Graph's Source Data
 

So I have 8 graphs on one tab that reference data on another. I
highlighted both tabs, click copy, and I was hoping the graph's source
data would move itself to the new data tab, but no dice. They are
still referencing the original tab. Is there a way to move all the
new graph's source data to the new tab all at once?

Regards,

Tyson

Changing Multiple Graph's Source Data
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TysonE" wrote in message
...
So I have 8 graphs on one tab that reference data on another. I
highlighted both tabs, click copy, and I was hoping the graph's source
data would move itself to the new data tab, but no dice. They are
still referencing the original tab. Is there a way to move all the
new graph's source data to the new tab all at once?

Regards,

Tyson

Changing Multiple Graph's Source Data
 

On Feb 3, 3:10*pm, "Don Guillett" wrote:
* * * If desired, send your file to my address below. I will only look if:
* * * 1. You send a copy of this message on an inserted sheet
* * * 2. You give me the newsgroup and the subject line
* * * 3. You send a clear explanation of what you want
* * * 4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"TysonE" wrote in message

...

That seems like more work than it's worth between us. I was just
looking for a quick answer. Worst case I go into each graph and
change the tab name.

Tyson


So I have 8 graphs on one tab that reference data on another. *I
highlighted both tabs, click copy, and I was hoping the graph's source
data would move itself to the new data tab, but no dice. *They are
still referencing the original tab. *Is there a way to move all the
new graph's source data to the new tab all at once?

Regards,

Tyson- Hide quoted text -

- Show quoted text -

Changing Multiple Graph's Source Data
 

A macro can do this for you but I don't have time to recreate your project
to test my solution. have it your way.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TysonE" wrote in message
...
On Feb 3, 3:10�pm, "Don Guillett" wrote:
� � � If desired, send your file to my address below. I will only look if:
� � � 1. You send a copy of this message on an inserted sheet
� � � 2. You give me the newsgroup and the subject line
� � � 3. You send a clear explanation of what you want
� � � 4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"TysonE" wrote in message

...

That seems like more work than it's worth between us. I was just
looking for a quick answer. Worst case I go into each graph and
change the tab name.

Tyson


So I have 8 graphs on one tab that reference data on another. �I
highlighted both tabs, click copy, and I was hoping the graph's source
data would move itself to the new data tab, but no dice. �They are
still referencing the original tab. �Is there a way to move all the
new graph's source data to the new tab all at once?

Regards,

Tyson- Hide quoted text -

- Show quoted text -

Changing Multiple Graph's Source Data
 

Basic idea

Sub changechartseries()
ms = 1
ActiveSheet.ChartObjects("Chart 3") _
..Chart.SeriesCollection(1).Values = _
"=Sheet" & ms & "!R1C1:R10C1"
End Sub


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...

A macro can do this for you but I don't have time to recreate your project
to test my solution. have it your way.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TysonE" wrote in message
...
On Feb 3, 3:10�pm, "Don Guillett" wrote:
� � � If desired, send your file to my address below. I will only look
if:
� � � 1. You send a copy of this message on an inserted sheet
� � � 2. You give me the newsgroup and the subject line
� � � 3. You send a clear explanation of what you want
� � � 4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"TysonE" wrote in message

...

That seems like more work than it's worth between us. I was just
looking for a quick answer. Worst case I go into each graph and
change the tab name.

Tyson


So I have 8 graphs on one tab that reference data on another. �I
highlighted both tabs, click copy, and I was hoping the graph's source
data would move itself to the new data tab, but no dice. �They are
still referencing the original tab. �Is there a way to move all the
new graph's source data to the new tab all at once?

Regards,

Tyson- Hide quoted text -

- Show quoted text -