Multiple graphs changing one day simultaniously
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.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By JamesBedford in forum Excel General
Last Post: 10-04-2018, 04:00 PM
By hunterage2000 in forum Excel General
Last Post: 01-30-2016, 06:22 AM
By AmatÝr in forum Excel Programming / VBA / Macros
Last Post: 03-16-2015, 10:23 AM
By mufan in forum Excel Charting & Pivots
Last Post: 02-12-2014, 04:49 PM
By brharrii in forum Excel Programming / VBA / Macros
Last Post: 01-30-2013, 11:52 AM
By Spaceman56 in forum Excel General
Last Post: 09-16-2011, 01:03 PM
By Cmorgan in forum Excel - New Users/Basics
Last Post: 06-20-2011, 12:26 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1