chart reference

  1. F

    Directly reference table column in chart

    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...
    • FarazM
    • Thread
    • chart reference dynamic cell references named range table column name
    • Replies: 1
    • Forum: Excel Questions
  2. Grizlore

    Can you chart a series with GetPivotData (or something like?)

    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...
  3. twinetwstr

    Chart Range quoting problem

    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...
  4. M

    dynamic chart help

    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...
  5. J

    vba to make all charts in ws reference active sheet

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

Watch MrExcel Video

Learn Excel - Slicer For Two Data Sets - Podcast 2198

This Week's Hot Topics

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
Top