+ Reply to Thread
Results 1 to 2 of 2

HELP! Repetitively having to use new data in the same chart

  1. #1
    Registered User
    Join Date
    02-03-2021
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    1

    HELP! Repetitively having to use new data in the same chart

    So my problem is that everyday I get sent a table of data which I then have to paste into an excel sheet. I repeatedly put a new table in everyday, 2 cells below the last table of data.

    Then I plot the data from the 13th column of the tables into the same graph everyday to see trends.

    I am having to manually do this everyday for multiple data sets.

    I need a way of just pasting the data tables in everyday to below each other and the graphs just automatically updating. I have attached an example of the data I am looking at with the graph which i update.

    PLEASE HELP ME THIS IS DRIVING ME INSANE.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    156

    Re: HELP! Repetitively having to use new data in the same chart

    Hi
    there are different options, like Powerquery or an VBA solution.

    Question is: How do you get the new data and how do they look like as you get them (csv, download from somewhere,..).
    Do you need the new data in the table with 2 rows gap or you just need the chart updated?

    Please clarifiy, then its easier to understand what is the best way for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to use Formula in Chart Filters > Edit Data > Chart Data Range
    By GregM56 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-04-2019, 05:27 PM
  2. Need autosum to work repetitively in a column
    By jsalleras in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-30-2017, 08:07 PM
  3. Add data repetitively in same box
    By T86157 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-27-2014, 11:25 PM
  4. Replies: 2
    Last Post: 10-16-2014, 08:57 PM
  5. [SOLVED] VBA Code for Deleting 2 Rows Repetitively
    By kitcargray in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2012, 10:36 AM
  6. Replies: 2
    Last Post: 05-22-2009, 02:29 PM
  7. Can a MACRO be written to run repetitively until cells equals zero?
    By phx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1