• Auto updates

    Author
    Topic
    #357303

    Are you adding new data to a range of cells and then wish to automatically update the chart?

    Viewing 1 reply thread
    Author
    Replies
    • #530572

      > I can of course updated by double clicking on the range and then dragging it to include the new data,<

      It seems to me that you can do this with a VBA macro.

      1. Identify the new data range, first cell/last cell
      2. Assign the range (as a string value) to the chart property that needs it.
      3. Initiate the action with a button on the sheet(s)

      What do you think?

    • #530580

      Set your chart series to extend 1 row beyond the last row of data. As long as the new data row is inserted and not pasted on top of that blank row, your chart series will automatically expand to include the inserted row.

      You’ll have to tolerate one empty column at the right of your charts, which shouldn’t bother anyone. Or you can change all charts to line charts, and have some more options about shifting axes. This method doesn’t work well with area charts, which zoom down to zero on any blank point in their series.

      Aloha,

      JohnJ

    Viewing 1 reply thread
    Reply To: Auto updates

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: