I'm looking to reference a table column for my chart data,
=Workbook1.xlsx!Table1[Values]
If possible it would be even better to be able to dynamically change the table name using the INDIRECT formula:
=INDIRECT("Workbook1.xlsx!Table"&$A$1&"[Values]")
where A1=1/2/3/etc.
Currently the only...
Can you chart with GetPivotData (or something like?)
I have a sheet with numerous charts, plotting data from a pivot.
The chart are using series values like this =ScorecardData!$B$8:$N$8
This is fine, however when the pivot changes, I lose the references and everything gets mixed up.
Is there...
This should be so simple!
I am building a subroutine to create a chart based on a selected group of
cells in separated columns.
If I hard-code the statement as
>>> Set ChrtRange = Range("B5:B8,K5:K8")
I can plug ChrtRange into
>>> CH.Chart.SetSourceData Source:=ChrtRange...
Hi
I have a chart that will shrink and grow in width between 3-12 columns
My problem is how to dynamically allow this
I have a formula which works out the address of the last cell in the range which appears to be working and I have concatenated that with some fixed cell bits so I end up with a...
Hi there. I'm very new to VBA, and I need a macro that makes all embedded charts on a worksheet reference that worksheet. Situation arises because I copied a worksheet with heaps of charts on it, but the charts in the new copy of the worksheet all reference the old worksheet.
Can someone help...
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.