+ Reply to Thread
Results 1 to 2 of 2

Creating the same graphs from several different data sources

  1. #1
    Registered User
    Join Date
    04-12-2017
    Location
    Maryland, US
    MS-Off Ver
    2013
    Posts
    1

    Question Creating the same graphs from several different data sources

    This is my very first post, so I apologize if it’s not descriptive enough or in the wrong thread.

    I have a task that requires me to generate the same set of graphics (about 14) for roughly 8 different sets of data. The data sets are in almost identical formats, but require some data transformations prior to creating the graphics.

    Firstly, I’m looking to do this as efficiently as possible and I’m wondering if this process would best be completed through Macros, or a combination of different techniques (i.e., templates, manual data cleaning, and manual copy-pasting the data, using an “offset” command, recording macros). What would you all suggest?

    Secondly, I have almost no knowledge of macros so any help there would be great.

    To reiterate, I’m curious on how best/ideal to go from data to graphics in a more automatic and efficient way.

    Thank you.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Creating the same graphs from several different data sources

    Hmm, question is bit too generic to give you specific answer...
    However, as long as your raw data in flat table structure...

    I'd recommend leveraging PowerQuery and/or PowerPivot if you have access to it.
    It's specifically designed to merge and transform data sets from multiple sources.

    If above isn't an option for you. MS Query can serve as an alternative.

    Uploading sample data sets along with desired result should get you faster and better response from members.

+ 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. Creating Automated Graphs with Data
    By yaakbari in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2013, 09:49 PM
  2. Creating a chart with multiple data-sources that have variable ranges ( in VBA)
    By Brocktanor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2013, 02:07 PM
  3. Creating a report with text data from multiple data sources
    By radionut in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2013, 10:17 AM
  4. [SOLVED] Excel 2007 : Creating a pivot table with multiple data sources
    By tiggynook in forum Excel General
    Replies: 3
    Last Post: 05-30-2012, 01:56 PM
  5. Replies: 0
    Last Post: 02-17-2012, 07:33 PM
  6. Replies: 2
    Last Post: 12-06-2011, 06:22 AM
  7. Help creating 3D graphs with x, y, z
    By surc6 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2011, 12:54 PM
  8. creating a chart with multiple data sources
    By ravihotwok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2010, 07:59 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