+ Reply to Thread
Results 1 to 2 of 2

Multiple graphs changing one day simultaniously

  1. #1
    Registered User
    Join Date
    05-23-2019
    Location
    Stiens, Netherlands
    MS-Off Ver
    Office 2013
    Posts
    1

    Question Multiple graphs changing one day simultaniously

    Hi guys,

    i have a workbook with a lot of graphs in there. Currently about 30 in different sheets. It's expanding in a week or so with another 20.
    Every morning i get updates in my system that is put in excel. After that i have to manually change every chart so that the data selection goes one to the right and removes one from the first. ( like a 2 weeks period of data that is showing )
    So for instance the select data is at first: B2:O4 and after change it's C2:P4.

    I've found some possible solutions on the internet but they keep crashing my charts and legends data.
    I also have tried changing some parts to tables and making dynamic graphs but that didn't work either. Changing the data to vertical instead of horizontal doesn't work either.

    Does anyone knows a good solution to my problem. I like to have one by vba instead of rewriting my whole excel document.

    Thanks in advance for everyone trying to help or assist me in any way.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,895

    Re: Multiple graphs changing one day simultaniously

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. VBA - changing colour of all graphs
    By JamesBedford in forum Excel General
    Replies: 1
    Last Post: 10-04-2018, 04:00 PM
  2. Need way of changing graph line colour for multiple graphs
    By hunterage2000 in forum Excel General
    Replies: 2
    Last Post: 01-30-2016, 06:22 AM
  3. How to interact data in two worksheets simultaniously...
    By AmatÝr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2015, 10:23 AM
  4. multiple graphs on one screen and moving graphs
    By mufan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-12-2014, 04:49 PM
  5. Created an Excel form used simultaniously by multiple users
    By brharrii in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2013, 11:52 AM
  6. Replies: 2
    Last Post: 09-16-2011, 01:03 PM
  7. Changing the order of graphs in 2010
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-20-2011, 12:26 PM

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