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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 35
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top