Setting Source Data in Active Charts

S

SBF12345

Well-known Member
Joined
Jul 26, 2014
Messages
614
I have a relative reference macro that I would like to produce a chart. Is it possible to set the "sheet" to activesheet or something similar, so that the activechart will produce a chart for the sheet that is open and not the sheet used to record the macro initially?

:eek:
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
You must log in or register to reply here.

Similar threads

T
  • Question
Set source data for a Map
Replies
0
Views
105
tiredofit
T
A
  • Question
Series Chart and Data with IF Statement
Replies
2
Views
266
NdNoviceHlp
NdNoviceHlp
M
  • Solved
Problem setting chart source
Replies
3
Views
251
mcomp72
M
N
  • Question
Stacked Chart to show value and status YTD
Replies
2
Views
293
neilo1969
N
Y
  • Question
Chart only part of a table
Replies
1
Views
270
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,214,810
Messages
6,121,690
Members
449,048
Latest member
81jamesacct

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top