vba chart souce data

  1. M

    Chart based on table not updating as expected (VBA)

    Hi I've written a macro which updates a clustered column chart in Sheet 1 that's based on data in a table in Sheet 2. However, the chart is not fully updating. The ‘source data’ for the chart is =Table5[#All] (based on a table that currently exists in Sheet2). The table in Sheet 2 is...
  2. L

    vba chart range

    Hi All, I have a question regarding charts, and was hoping someone might be able to help. If you have an embedded chart with a series in it, is it possible, using vba, to obtain the x or y values/range referenced, and then write that to a cell. e.g. if the x-values for series Case 2 is...

Some videos you may like

This Week's Hot Topics